| title | Execute SQL Server Agent Job Task | |||
|---|---|---|---|---|
| description | Execute SQL Server Agent Job Task | |||
| author | chugugrace | |||
| ms.author | chugu | |||
| ms.date | 03/14/2017 | |||
| ms.service | sql | |||
| ms.subservice | integration-services | |||
| ms.topic | concept-article | |||
| f1_keywords |
|
|||
| helpviewer_keywords |
|
[!INCLUDEsqlserver-ssis]
The Execute [!INCLUDEssNoVersion] Agent Job task runs [!INCLUDEssNoVersion] Agent jobs. [!INCLUDEssNoVersion] Agent is a [!INCLUDEmsCoName] Windows service that runs jobs that have been defined in an instance of SQL Server. You can create jobs that execute Transact-SQL statements and ActiveX scripts, perform [!INCLUDEssASnoversion] and Replication maintenance tasks, or run packages. You can also configure a job to monitor [!INCLUDEmsCoName] [!INCLUDEssNoVersion] and fire alerts. [!INCLUDEssNoVersion] Agent jobs are typically used to automate tasks that you perform repeatedly. For more information, see Implement Jobs.
By using the Execute [!INCLUDEssNoVersion] Agent Job task, a package can perform administrative tasks related to [!INCLUDEssNoVersion] components. For example, a [!INCLUDEssNoVersion] Agent job can run a system stored procedure such as sp_enum_dtspackages to obtain a list of packages in a folder.
Note
[!INCLUDEssNoVersion] Agent must be running before local or multiserver administrative jobs can run automatically.
This task encapsulates the sp_start_job system procedure and passes the name of the [!INCLUDEssNoVersion] Agent job to the procedure as an argument. For more information, see sp_start_job (Transact-SQL).
You can set properties through [!INCLUDEssIS] Designer. This task is in the Maintenance Plan Tasks section of the Toolbox in [!INCLUDEssIS] Designer.
For more information about the properties that you can set in [!INCLUDEssIS] Designer, click the following topic:
For more information about how to set these properties in [!INCLUDEssIS] Designer, click the following topic: