Automation Engine Script Guide > AE JCL for SQL > About SQL JCL

About SQL JCL

AE provides specific scriptA particular Automation Engine object type. elements for SQL jobs. Results are written to a reportA report provides more detailed information about a task's execution or a component. and can be read using PREP_PROCESS_REPORT.

Script Element

Script element

Description

SQL_EXECUTE_JOB

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

SQL_GET_COLUMNS

Supplies information about a table's columns.

SQL_GET_JOBS

Supplies a listShows entities in a grid view of all defined jobs of an MS SQL Server.

SQL_GET_TABLES

Lists all databaseA database is an organized collection of data including relevant data structures. tables.

SQL_ON_ERROR

Determines the reaction to SQL errors.

SQL_ON_ROWCOUNT_ZERO

Determines the return codeThe value that represents the result of tasks and script functions. if an SQL statement does not supply a hit.

SQL_SET_STATEMENT_TERMINATOR

Determines the character that terminates SQL statements.

 

See also:

Form (SQL)

 


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

Copyright © 2016 Automic Software GmbH