Calling jobs from SP

[Nowell]

Hi,

I have a stored proc that calls two jobs, like so:

exec pelican.msdb.dbo.sp_start_job @job_name=
'restore = alpha pm'

exec pelican.msdb.dbo.sp_start_job @job_name=
'restore = Omega PM'

Will the second job wait for the first job to complete before it executes?

 

[JayKusch]

I do not beleive that it will wait on the first job executed to complete

Thanks

J. Kusch

 

[Nowell]

Ok thanks,

Is there anyway I can make it do that, basically I want the restores to run:

a. once the backup has completed
b. second restore to run after the first one has completed as they will be using the same file.

thanks mate

 

[JayKusch]

May want to wrap both of those jobs into just one job. Each backup/restore as a single step. You can the set the job to fail and stop running if one step does not complete and to continue if all is fine.

Thanks

J. Kusch

 

[nigelrivett]

You could also have the job log completion to a table and wait on that or query msdb..sysjobhistory for completion

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[Nowell]

Hi,

How about if I call the first job from the stored proc, then call the second job from the store proc in the first job, will that work ok?