SQL_GET_JOBS

The SQL_GET_JOBS script element supplies a list of all the defined jobs of an MS SQL Server. The agent uses the vsp_help_job stored procedure in the msdb database to retrieve MS SQL jobs. The report prints each MS SQL job in a separate line.

Important! 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.

Syntax

SQL_GET_JOBS

Example

SQL_GET_JOBS;