Schedule the execution of SSIS packages deployed in Azure with SQL Server Management Studio (SSMS)

Artikel
02/28/2023

Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory

You can use SQL Server Management Studio (SSMS) to schedule SSIS packages deployed to Azure SQL Database. SQL Server on premises and SQL Managed Instance have SQL Server Agent and Managed Instance Agent respectively as a first-class SSIS job scheduler. SQL Database, on the other hand, does not have a built-in first-class SSIS job scheduler. The SSMS feature described in this article provides a familiar user interface that's similar to SQL Server Agent for scheduling packages deployed to SQL Database.

If you're using SQL Database to host the SSIS catalog, SSISDB, you can use this SSMS feature to generate the Data Factory pipelines, activities, and triggers required to schedule SSIS packages. Later you can optionally edit and extend these objects in Data Factory.

When you use SSMS to schedule a package, SSIS automatically creates three new Data Factory objects, with names based on the name of the selected package and the timestamp. For example, if the name of the SSIS package is MyPackage, SSMS creates new Data Factory objects similar to the following:

Object	Name
Pipeline	Pipeline_MyPackage_2018-05-08T09_00_00Z
Execute SSIS Package activity	Activity_MyPackage_2018-05-08T09_00_00Z
Trigger	Trigger_MyPackage_2018-05-08T09_00_00Z

Prerequisites

The feature described in this article requires SQL Server Management Studio version 17.7 or higher. To get the latest version of SSMS, see Download SQL Server Management Studio (SSMS).

Schedule a package in SSMS

In SSMS, in Object Explorer, select the SSISDB database, select a folder, select a project, and then select a package. Right-click on the package and select Schedule.
The New Schedule dialog box opens. On the General page of the New Schedule dialog box, provide a name and description for the new scheduled job.
On the Package page of the New Schedule dialog box, select optional run-time settings and a run-time environment.
On the Schedule page of the New Schedule dialog box, provide the schedule settings such as frequency, time of day, and duration.
After you finish creating the job in the New Schedule dialog box, a confirmation appears to remind you about the new Data Factory objects that SSMS is going to create. If you select Yes in confirmation dialog box, the new Data Factory pipeline opens in the Azure portal for you to review and customize.
To customize the scheduling trigger, select New/Edit from the Trigger menu.

The Edit Trigger pane opens for you to customize the scheduling options.