Click here to Skip to main content
12,746,296 members (31,231 online)
Rate this:
Please Sign up or sign in to vote.
See more: SQL
Hi iam with a new company now they are using SSIS Packages and these packages are in SQL jobs. with steps. can i create a job that will controll all the jobs? they want me to create a table where all the jobs,stored proceedures and the schedules of jobs are stored and the job that i will create will fetch from the table what job is to be executed in sequence. Please help me to have an idea how iam gonna do this.

Thank you very much!
Posted 30-Sep-12 16:51pm
JOEY G. MOYA 1-Oct-12 2:44am
Thank you for sugguestion but if i may explain further what i need to accomplish in relation to my AUTOMATE SSIS Jobs. There are already jobs calling ssis packages which runs different schedules for exampl job sampl1 with three packages runs every four hours, another job some packages and steps run every shift morning,afternoon and midnight. What i need to do is to have a table containing all the jobs and packages,iam not sure if i need to create a package which fetch from table what job is to be executed in sequence or create a console application to call job from table and execute whatever is in sequence from table.

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Use foreach loop:[^]

Then use "Execute SQL Server Agent Job Task" and set your variable for expression for this task.[^]

You may also try sp_startjob stored proc too:
Execute SQL Server Agent Job Task[^]

You can also use Script Task to Run SQL Agent Job, have a look at :
Manage SQL Server Agent Jobs using C#[^]

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170215.1 | Last Updated 30 Sep 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100