I need to use sp_start_job to schedule two jobs in SQL Server : the second job may run only if the first succeds.
Can you give me an example of a job running this store procedure to do this ?
Is there another method to do this in SQL Server ?
Thanks in advance !
Software/Hardware used:
ASKED:
February 12, 2008 6:44 PM
UPDATED:
April 22, 2011 4:31 PM
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.
Thanks a lot : the first is a very nice solution !
I think the first solution is better!
I have problems in mainteinance of two jobs (they are modified by automatic setups).
So I think the best solution is executing a batch running two times sp_start_job (one for the first job and one for the second job).
The second job can execute only if the first runs succesfully.
I don’ t know if this is possible (now I try some exemple).
Thank in advance for every hint!