Execute SQL Server Agent Job Task
The Execute SQL Server Agent Job task runs jobs configured in SQL Server Agent. You can create a variety of jobs under SQL Server Agent. For example, the jobs can be ActiveX script jobs or replication jobs, which can be run from within SSIS package using this task. SQL Server Agent is a Windows service and must be running for jobs to run automatically.
The task interface is intuitive and easy to configure as you can make out from Figure 5-33. You specify a connection to the SQL Server. The task reads the SQL Server Agent jobs from the specified SQL Server and lists them under the Available SQL Server Agent Jobs area. You then select the job you want to run from the list provided.
Figure 5-33. Interface for Execute ...
Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
