|
SQL_GET_COLUMNS |
AE JCL for SQL |
SQL_GET_TABLES |
|
Supplies a list of all defined jobs of an MS SQL Server.
SQL_GET_JOBS
The agent uses the stored procedure vsp_help_job in the databaseA database is an organized collection of data including relevant data structures. 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.
SQL_GET_JOBS;
See also: