One of AE's components is an 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 that can be used to establish connections to databases. It facilitates the execution of SQL statements in these databases without an external command line tool being required. In doing so, security is increased and databaseA database is an organized collection of data including relevant data structures. administration simplified. In addition to typical SQL statements such as SELECT or UPDATE, the agent can process database-specific commands and stored procedures in the database.
The Job objectAutomation Engine controlled activities and processes are structured in the form of objects. See also: Task includes an editor that makes it easy to specify SQL statements. Additionally it displays database tables and columns.
The result of the SQL statements are stored in a jobAn Automation Engine object type for a process that runs on a target system. reportA report provides more detailed information about a task's execution or a component. which can be read using the scriptA particular Automation Engine object type. statement PREP_PROCESS_REPORT. If an error occurs during job execution or if the job aborts, the agent cancels all SQL statements until the last COMMIT. The Job object provides many possible ways to configure the execution of SQL statements.
The AE agent for databases currently supports Oracle, MSSQL, DB2 and MySQL.
See also:
Automic Documentation - Tutorials - Automic Blog - Resources - Training & Services - Automic YouTube Channel - Download Center - Support |
Copyright © 2016 Automic Software GmbH |