Automation Engine Script Guide > AE JCL for SQL > SQL_EXECUTE_JOB

SQL_EXECUTE_JOB

Executes a jobAn Automation Engine object type for a process that runs on a target system. on the MS SQL Server.

Syntax

SQL_EXECUTE_JOB JOB=...

Syntax

Description/Format

JOB=

Name of the MS SQL job.

Comments

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 sp_start_job in the databaseA database is an organized collection of data including relevant data structures. msdb in order to start the MS SQL jobs.

The statusThis represents the condition of a task (such as active, blocked, generating). of the AE job depends on the started job's execution:

Status of the MS SQL job

Status of the AE job

MS SQL job has successfully ended

ENDED_OK

MS SQL job has aborted

ENDED_NOT_OK

User has canceled the MS SQL job

ENDED_CANCEL

The AE job also 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 has been used.

The agent calls the stored procedure sp_stop_job if you terminate the AE job while the MS SQL job is still active. In doing so, the MS SQL job does not abort immediately and is monitored until its end has been defined.

The scriptA particular Automation Engine object type. element SQL_GET_JOBS lists all available MS SQL jobs.

Examples

SQL_EXECUTE_JOB JOB="Integrity Checks Job for DB Maintenance Plan";

 

See also:

 


Automic Documentation - Tutorials - Automic Blog - Resources - Training & Services - Automic YouTube Channel - Download Center - Support

Copyright © 2016 Automic Software GmbH