I'm using 2008 R2 I have a job which executes 1 SSIS package.
My problem is that the job (somehow!) also executes 4 other jobs. I scripted the job and it only has 1 step and that step executes the correct SSIS package. And nothing in that package refers to any other packages.
I'm scratching my head on this one. Have you ever seen this issue?
Recreated both, using different names than the original.
Now the job doesn't also execute other jobs.
I have worked with SQL Server since version 7. This was one of the strangest problems I've encountered.
Closing this thread. Jack
I'm sure it had some event handler logic which called and executed the other jobs. Or may be some trigger logic on tables the package used to call the other jobs, otherwise this wont happen
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
Agent Job Also Runs *OTHER* Jobs
Posted - 02/18/2013 : 15:38:18
