Click here to Skip to main content
11,639,765 members (61,462 online)
Rate this: bad
good
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 15:51pm
Comments
JOEY G. MOYA at 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
good
Please Sign up or sign in to vote.

Solution 1

Use foreach loop:
http://www.simple-talk.com/sql/ssis/implementing-foreach-looping-logic-in-ssis-/[^]

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

http://sqlserverrider.wordpress.com/2011/05/17/execute-sql-job-using-ssis/[^]

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#[^]
  Permalink  

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

  Print Answers RSS
0 Suvendu Shekhar Giri 330
1 CPallini 177
2 F-ES Sitecore 170
3 sasanka sekhar panda 155
4 jyo.net 142
0 OriginalGriff 9,081
1 Sergey Alexandrovich Kryukov 8,847
2 Mika Wendelius 7,027
3 Suvendu Shekhar Giri 2,650
4 F-ES Sitecore 2,558


Advertise | Privacy | Mobile
Web02 | 2.8.150731.1 | Last Updated 30 Sep 2012
Copyright © CodeProject, 1999-2015
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