June 28, 2010 at 9:16 am
Hello all,
I have a SQL Agent job which has 3 steps. After step 1 fires I want steps 2 and 3 to fire at the same time since they do not depend on one another.
Steps two and three are kicking off SSIS packages. I want to avoid having to create a third package which would fire the other two asynchronously. I'd rather just have my job fire two packages at same time after step 1 completes.
Can this be done?
Thanks,
Strick
June 28, 2010 at 9:52 am
Hi,
Hope this is not possible. due you want to save time on this or other.
Regards
Durai Nagarajan
June 28, 2010 at 10:54 am
Hi thanks for your response.
Yes, I want to save time and also utilize the server's resources since they are available. Sounds like I may have to go the third package route unfortunately.
Strick
July 30, 2010 at 10:33 pm
Create separate jobs for example 'Job-SSIS2' and 'Job-SSIS3' and in second step of the existing job(under which step 1 executes) create second step to invoke these two newly created jobs(via sp_execute job 'jobname') so that these SSIS2 and SSIS3 package jobs can execute at the same time.
HTH!
MJ
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply