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 |
Description |
---|---|
Executes a jobAn Automation Engine object type for a process that runs on a target system. on the MS SQL Server. |
|
Supplies information about a table's columns. |
|
Supplies a listShows entities in a grid view of all defined jobs of an MS SQL Server. |
|
Lists all databaseA database is an organized collection of data including relevant data structures. tables. |
|
Determines the reaction to SQL errors. |
|
Determines the return codeThe value that represents the result of tasks and script functions. if an SQL statement does not supply a hit. |
|
Determines the character that terminates SQL statements. |
See also:
Automic Documentation - Tutorials - Automic Blog - Resources - Training & Services - Automic YouTube Channel - Download Center - Support |
Copyright © 2016 Automic Software GmbH |