September 29, 2016 at 12:56 pm
We are running SQL Server 2012 EE SP3.
I have set up a single job with 3 steps. Each step executes a different ssis package. Each step has it's own schedule. I.e, Step 1 runs at 9 A.M., Step 2 runs at 10 A.M., and step 3 runs at 11 A.M. When the job runs, it appears that only the first step is being executed.
How do you get the actual step within a job to reference a particular schedule?
Or, do I need to create a separate job for each step for each schedule when scheduling ssis packages?
Thanks in advance.
September 29, 2016 at 3:33 pm
Job schedules are associated with Jobs themselves, not job steps. So it sounds like what you want is different jobs for each of the packages.
Sue
October 4, 2016 at 12:14 pm
HookSqlDba7 (9/29/2016)
We are running SQL Server 2012 EE SP3.I have set up a single job with 3 steps. Each step executes a different ssis package. Each step has it's own schedule. I.e, Step 1 runs at 9 A.M., Step 2 runs at 10 A.M., and step 3 runs at 11 A.M. When the job runs, it appears that only the first step is being executed.
How do you get the actual step within a job to reference a particular schedule?
Or, do I need to create a separate job for each step for each schedule when scheduling ssis packages?
Separate jobs.
Believe me, I've tried this before. There's no good option unless..
You can have multiple schedules on a job, but within each job step have an operating system command only execute the package under X, Y, and Z conditions (basically a big IF/ELSE check that does nothing on the ELSE condition). But just a note, this gets messy fast and is nigh-unmaintainable.
So, separate jobs.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply