SQL_GET_JOBS

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

Syntax

SQL_GET_JOBS

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.

Tip: You can write scripts that execute MS SQL jobs. For more information, see SQL_EXECUTE_JOB.

Example

SQL_GET_JOBS;