Create a job for a SSIS package (SSIS Catalog)

In this post, we will learn how to create a new job for the SSIS package which is deployed on the integration service server (SSIS Catalog).

Read: how to deploy the package on SSIS catalog

https://bageshkumarbagi-msbi.blogspot.com/2016/07/ssis-project-deployment-model-in-sql.html

Here I have a package. This is a simple package which is used to move some files from one folder to another folder.

This package is deployed on the SSIS catalog. See below.

  

Now I am going to create a SQL server agent job in SQL server for this package.

Now click on the SQL server agent Job. In the general tab, we provide the job name and job description.

  

Go to the Steps tab.

  

 

In Steps tab Select Type as SQL Server Integration service package and Package Source as SSIS catalog and provide the Server name where our packages are deployed. In the package tab, we need to select the package location from the SSISDB catalog.

Click ok.

Step is created.

  

Click ok.

A new job is created successfully.

  

Before executing this package see the Archive folder.

     

   

Now executing this job.

   

Job completed successfully. Now see the Archive folder.