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 |
|
JNotenboom
Starting Member
27 Posts |
 Posted - 2001-03-20 : 04:45:42
|
| Hello!I have a problem with running jobs in SQL 7.0.Here is the case:I have two jobs (job A & job B). these jobs simply execute a package each (package A & package B). Job B is allowed to start when the execution of package A is completed succesfull. This is because the data in job B depends on data in job A.For this, I created job C, which executes the two jobs in two seperate steps:step 1: EXEC sp_start_job @job_name = 'job A'step 2: EXEC sp_start_job @job_name = 'job B'The case is, that when I run job C, job A starts (Yippi ah yee, that is correct). Right after that, job B starts, but not on the 'on success' of package A (initialized by job A); it starts on the 'on success' of just the execute statement in job A. This is something that I do not want.How do I solve this? If this can not be solved: how do I make the execution of package B 'wait' for the completion of package A?thanxJohanIntelli Solutions (intelli.nl)wannaWAP.com |
|
|
|
|
|
Sequential jobs running