Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mtannir50
Starting Member
6 Posts |
 Posted - 2010-01-14 : 02:20:07
|
| Good day,We would appreciate your help on the following issue concerning running jobs on SQL Server 2005. We are trying to run successive jobs through a query using the command EXEC MSDB.DBO.SP_START_JOB 'JOB NAME'. It would really arrange us to run the next job in the queue once the previous one is terminated successfully. We tried to use the MSDB.dbo.sysjobhistory system table to track the job history and execution status but had some difficulties handling the complex output . Can anyone help us out on it by providing a running script to solve this matter or any other convenient solution?Thank you |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-14 : 03:17:43
|
| Can you just set up the various tasks as individual Steps in the Job ? |
 |
|
|
mtannir50
Starting Member
6 Posts |
Posted - 2010-01-14 : 03:59:00
|
quote:
Originally posted by Kristen
Can you just set up the various tasks as individual Steps in the Job ?
That's what we are doing.We are executing the various tasks through individual steps in the job. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-14 : 04:16:51
|
| So when you execute the job it just runs Step 1, then Step 2, ... automatically?(You may need to set the action to perform On Success and On Failure for each Step - using the "Advanced" tab)In which case I think I have misunderstood your question, can you explain please? |
|
|
|
|
|
|
Running successive jobs on SQL Server 2005