The following overview includes the attributes of a SQL Job objectAutomation Engine controlled activities and processes are structured in the form of objects. See also: Task and describes their functions, allowed values and ways of modification.
Keep in mind that :PUT_ATT may be used to set a databaseA database is an organized collection of data including relevant data structures. plus server (DATABASE_NAME, SERVER_NAME) or a Microsoft Access database. It is not possible to assign values to all three attributes because the access to the database would not be unique.
Predefined variables may be used in scripts, and script variables may be set to attributes retrieved via predefined variablesFixed variables that can be used in the attributes or the script of executable objects. The values refer to the object or the system..
Field |
Attribute |
Value |
Access Via: |
---|---|---|---|
Job reportA report provides more detailed information about a task's execution or a component. - Database |
JOBREPORT_DB |
"Y" - yes, "N" - no |
GET_ATT |
Job report - File |
JOBREPORT_FILE |
"Y" - yes, "N" - no |
GET_ATT |
Job report - Generate on error only |
JOBREPORT_ERROR_ONLY |
"Y" - Job report only saved if error occurs |
GET_ATT |
Optional reports - Agent log | SQL_AGENTLOG |
"Y" - yes, "N" - no |
GET_ATT :PUT_ATT (Pre-Process, Process) |
Connection - file name |
DATA_SOURCE |
User-defined, |
GET_ATT |
Connection - server |
SERVER_NAME |
User-defined, |
GET_ATT |
Connection - database |
DATABASE_NAME |
User-defined, |
GET_ATT |
Settings - Show headlines in tables | SQL_CAPTIONS |
"Y" - yes, "N" - no |
GET_ATT :PUT_ATT (Pre-Process, Process) |
Settings - Column separator | SQL_COLUMN_SEPERATOR | User-defined, maximum 1 character |
GET_ATT :PUT_ATT (Pre-Process, Process) |
Settings - Substitute character | SQL_SUBST_CHARACTER | User-defined, maximum 1 character |
GET_ATT :PUT_ATT (Pre-Process, Process) |
Settings - show NULL as empty string | SQL_SHOW_NULL |
"Y" - yes, "N" - no |
GET_ATT :PUT_ATT (Pre-Process, Process) |
Settings - Maximum number of rows for tables | SQL_MAX_ROWS | User-defined, value between "1" and "9999" |
GET_ATT :PUT_ATT (Pre-Process, Process) |
Settings - Remove line breaks | SQL_REMOVE_CRLF |
"Y" - yes, "N" - no |
GET_ATT :PUT_ATT (Pre-Process, Process) |
Settings - Maximum number of characters in a column | SQL_MAX_CHARACTERS | User-defined, value between "1" and "9999" |
GET_ATT :PUT_ATT (Pre-Process, Process) |
See also:
Job
Host Attributes Tab
Attributes
:PUT_ATT Statement
GET_ATT Function
AE DB Change
Automic Documentation - Tutorials - Automic Blog - Resources - Training & Services - Automic YouTube Channel - Download Center - Support |
Copyright © 2016 Automic Software GmbH |