Create SQL Server Agent jobs

This tutorial instructs how to create a SQL Server agent job to run the deployed SSIS Package from the tutorial SSIS Package Deployment. Follow the steps below:

Open SSMS, remember to start SQL Server Agent, then right click on Jobs -> New Job…

Name the job “Export to Excel”

Click on Steps -> New

Set the step name, type, run as, server and package as shown on the screenshot above

Click on Configuration -> Advanced

Check the 32-bit runtime checkbox and click on OK -> OK

Execute SQL Server Agent jobs

Under SQL Server Agent’s Jobs, right click on the “Export to Excel” job -> Start Job at Steps…

The job should run successfully

Congratulations!

Homework: can you self investigate and schedule the job to run automatically?