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 |
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
 Posted - 2012-02-22 : 18:09:09
|
| Greetings,I have many ssis packages scheduled in sql sql jobs. our admin wants to runs these in one sql job. so I wrapped them all in one sql job but they seem to fire off together instead of sequentially though I have them as steps in a job. Am I missing something here? other than creating yet a new ssis package that runs each individual ssis packages how else can I do this?Thanks!<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-02-22 : 19:00:38
|
| Just make them steps of one job. If you wrap the jobs in one job, you won't get them sequential, because sp_start_job doesn't wait for the job to finish.That said, I would make sure there's a very good reason for combining these before doing it. |
 |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-02-22 : 19:13:21
|
| thanks russel! just wrapped them up in another ssis package. indeed sp_start_job does not it just gallops on.<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
|
|
|
job that runs other sql jobs sequentially