Schedule SSIS Jobs Step by Step with Screenshots

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 the General tab - Enter your Job Name.

Step 5. In the Step tab - Click on the New button.

Step 6. Once you click on the New button -> below window will open.

• Add Step name
• Select Type as SQL Server Integration Package

In Package Option:

• Select Server
• Select the Package that you want to Schedule.
  

Now Select Configuration Option:

1. Check Parameters

2. Check Connection managers - Sometimes, you need to add a password if it's not autofill.
3. In the Advanced option - Select 32-bit runtime.

Then click OK. Now your step is created.

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

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

Step 8. Some more options are available on the left side, like Alerts, Notification, and Target. Leave it as it is, and click Ok.

Now your SSIS Job is scheduled.

Thank You!