EMS logo

Products Navigation

SQL Backup for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Backup for SQL Server

On-line Documentation

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 Quick Maintenance Actions | ExecuteJob 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

 

 


See also:

Backup database

Execute SQL Server Agent job

Execute T-SQL statement

History Cleanup

Database Integrity Check

Shrink Database

Reorganize Indices

Update Statistics

Database Parameters Logger

Maintenance Cleanup

Transaction Log Shipping

Database Shipping

Bulk Restore