SQL_GET_JOBS

Use SQL_GET_JOBS to retrieve a list of all defined jobs on an MS SQL Server. The agent uses the vsp_help_job stored procedure in the msdb database. Each MS SQL job is printed on a separate line in the report.

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

Tip: To execute MS SQL jobs from scripts, see SQL_EXECUTE_JOB.

Syntax

SQL_GET_JOBS

Examples

SQL_GET_JOBS;