User Guide > Objects > Alphabetical Listing > SQL

SQL

The document shown below explains the platform-specific settings for an SQL jobAn Automation Engine object type for a process that runs on a target system..

Description

Field/Control

Description

Job Report

 

Database

The job reportA report provides more detailed information about a task's execution or a component. is maintained in AE. When the job has been processed, the Automation EngineThis component drives an Automation Engine system and consists of different types of server processes. takes the process protocol which has been stored on 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 computer and stores it to the AE databaseA database is an organized collection of data including relevant data structures..

File

The job report is maintained in AE. The process log is available in the form of a file in the target system after job execution.

Only in the case of error

The job report is only stored in the AE database and/or in the form of a file in the target system if the job is canceled. This checkbox is only available when "Database" and/or "File" have/has been checked.

Optional reports  
Agent log Activating this checkbox has the effect that a report including the agent's messages about the job execution is added to the taskAn executable object that is running. Tasks are also referred to as activities..

Connection

 

Connection objectAutomation Engine controlled activities and processes are structured in the form of objects. See also: Task

The DB Connection object that is used for the connection to the database.

When you specify a Connection object, this object's connection data is used and the definition that have been made in the Job object (in the text fields "Server" and "Database") will be ignored.

When a Login object is defined in the job's Attributes tab, this object's loin information will be used. When no Login object is defined, the loginAn Automation Engine object type that stores account credentials used by agents on target systems. information will be retrieved from the Connection object.
The job will abort when there is neither a Login object nor a Connection object definition.

The job will also fail when the database types of the agent and the Connection object do not match.

Server

Name of the computer on which the database has been installed

Format: Server name:Port
Example: PC01:2281

The standard ports are

  • MS SQL Server: 1433
  • Oracle: 1521
  • DB2: 50000
  • MySQL: 3306

It is not required to fill in this field if the job should be processed in an Oracle database in RAC.

Informix requires the port to be specified.

Database

Name of the database

Informix requires the name of the Informix Server and the database name to be separated by a slash.
Example: ol_ids_1110_1/ang 

File name

Path and file name of the MS Access database

Settings

 

Show headlines in tables

Setting for the display of table headlines

Show NULL as empty string

This option displays a field with the content NULL in the form of an empty string "".

Remove line breaks

This setting removes all line breaks used in a column.

Column separator

Character used to separate columns in the results of SELECT statements.

Substitute character

If the character specified as column separator is used within a database field, the substitute character specified here is used.

Max. number of lines in tables

If the result of an SQL statement contains more lines than specified here, these are truncated.

This limitation applies to each SQL statement.

The number of lines is not limited if value "0" is specified.

Max. number of characters in a table column

The content of a database field is truncated if it comprises of more characters than specified here.

Database fields whose contents were specified as numbers or time stamps are not truncated.

Note that there are limitations to the scriptA particular Automation Engine object type. functionPre-defined run book template in the Automation Engine. One single step only, e.g. Start Windows Service, Copy file,… PREP_PROCESS_REPORT when the report is read column by column.

 

 


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

Copyright © 2016 Automic Software GmbH