Execute SQL Server Agent job

Execute SQL Server Agent job step allows you to execute an SQL Server Agent job on the server.

A job is a specified set of operations performed sequentially by SQL Server Agent. A job can perform a wide range of activities, including running Transact-SQL scripts, command-line applications, Microsoft ActiveX scripts, Integration Services packages, Analysis Services commands and queries, or Replication tasks. Jobs can run repetitive or scheduled tasks, and they can automatically notify operators of job status by generating alerts. Before using SQL Server jobs, make sure that the SQL Server Agent service is running.

Note: The status of this step execution shows whether a job has been launched or failed to launch, and not the result of job execution.

To launch the job immediately select Quick Maintenance Actions | Execute SQL Server Agent job popup menu item in the Servers tab.

To perform scheduled execution of SQL Server Agent job on regular basis you need to include this task into Policy:

1. At Step 2 of the Create Policy wizard click Create new step button and select Execute SQL Server Agent job type.

2. Also, you can create a new Step Template for further use selecting Execute SQL Server Agent job step at the Templates tab.

Steps of the Execute SQL Server Agent job wizard:

Naming step

Selecting job

Performing operation