Home > SQL Server, SSIS > Execute SQL Server Agent Job Task – SSIS 2012

Execute SQL Server Agent Job Task – SSIS 2012


Executing SQL Agent jobs is very simple with Execute SQL Server Agent Job Task in SSIS 2012. SSIS 2012 got a new task that helps us to execute jobs store in the SQL Server Agent.

Implementation

Step 1: Create a package and add Execute SQL Server Agent Job Task

Step 2: Create database connection and point to the SQL Server that has jobs

 

 

 

 

 

 

 

 

Step  3: Open Execute SQL Server Agent Job Task. Select Database connection and Job to execute.

 

 

 

 

 

 

 

I have given dot (.) for connection name and TestJob for job name. You can use your own job and connection.

Step 4: Now, execute package and go to Job Activity Monitor in SQL Server Agent

Package execution

 

 

 

Job Activity Monitor

 

 

 

 

 

Thanks for using Execute SQL Server Agent Job Task. And, Thanks for reading.

Advertisements
  1. No comments yet.
  1. February 27, 2012 at 7:06 am

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: