SQL_GET_JOBS

Supplies a list of all defined jobs of an MS SQL Server.

Syntax

SQL_GET_JOBS

Comments

The agent uses the stored procedure vsp_help_job in the database msdb to retrieve MS SQL jobs. The report prints each MS SQL job in a separate line.

The AE job aborts if the user is not authorized or if a database other than Microsoft SQL Server is used.

The script element SQL_EXECUTE_JOB can execute MS SQL jobs.

Examples

SQL_GET_JOBS;

 

See also: