Execute SQL Server Agent Job Task

The execute sql server agent job task runs sql server agent jobs. Sql server agent is a Microsoft 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 active scripts, perform analysis services and replication maintenance tasks, or run packages. You can also configure a job to monitor Microsoft sql server and fire alerts. Sql server agent jobs are typically used to automate tasks that you perform repeatedly.

Step 1:

Drag and drop execute sql server agent job task in control flow and edit it. Give a new connection as execute sql server agent job task

.

Step 2:

In available execute sql server agent jobs select a job.

Step 3:

Click on view T-SQL

Step 4:

Execute a task