Supplies a listShows entities in a grid view of all defined jobs of an MS SQL Server.
SQL_GET_JOBS
The agentA program that enables the de-centralized execution of processes (such as deployments) on target systems (computers or business solutions) or a service that provides connectivity to a target system (such as for databases or middleware). An agent is also an object type in the Automation Engine. [Formerly called "Executor."] See also: host uses the stored procedure vsp_help_jobAn Automation Engine object type for a process that runs on a target system. in the databaseA database is an organized collection of data including relevant data structures. msdb to retrieve MS SQL jobs. The reportA report provides more detailed information about a task's execution or a component. prints each MS SQL job in a separate line.
The AE job aborts if the userIn the Automation Engine, a user is an instance of a User object, and generally the user is a specific person who works with Automic products. The User object is assigned a user ID and then a set of access rights to various parts of the Automation Engine system and product suite. These access rights come in the form of Automation Engine authorizations and privileges, Decision user roles and EventBase rights and ARA web application object rights. You can manage all these centrally in the ECC user management functions. See also, Unified user management. is not authorized or if a database other than Microsoft SQL Server is used.
The scriptA particular Automation Engine object type. element SQL_EXECUTE_JOB can execute MS SQL jobs.
SQL_GET_JOBS;
See also:
Automic Documentation - Tutorials - Automic Blog - Resources - Training & Services - Automic YouTube Channel - Download Center - Support |
Copyright © 2016 Automic Software GmbH |