How to Schedule SSIS Job - Step by Step Guide - With Related Screen Shot.

 

Follow the below steps:

Step-1: First deploy the SSIS Package under Integration Services Catalogs.

Step-2: Expand SQL Server Agent option -> Jobs -> Create New Job

Step-3: Once click on New Job below window will open:

Step-4: In General tab - Enter your Job Name.

Step-5: In Step tab - Click on New button 

Step-6: Once click on New button -> below window will open : 

a. Add Step name  

b. Select Type as SQL Server Integration Package 

In Package Option:

a. Select Server 

b. Select Package that you want to Schedule. 

Now Select Configuration Option: 

a. Check Parameters

                                        

b. Check Connection managers - Sometime Need to add password if its not autofill.

c. In Advanced option - Select 32-bit runtime

Then click OK. Now your step created. 

Step-7: Now click on left Schedules option -> Click New Button -> Below window will open:

Fill all the details as per your requirements and click OK.

Step-8: Some more options are available in left side like Alerts , Notification, Target leave as it is and click Ok. 

Now your SSIS Job is scheduled. 

Thank You! 

For more details please watch the below Video: