Help me automate ssis jobs

Question

0.00/5 (No votes)

See more:

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

JOEY G. MOYA

Add a Solution

Comments

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

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Kuthuparakkal · Accepted Answer · 2012-09-30T17:40:00

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