Databases Job

The following table describes the Databases job type attributes.

Attribute	Description
Connection Profile	Determines the authorization credentials that are used to connect Control-M to Databases. Rules: Characters: 1−30 Case Sensitive: Yes Invalid Characters: Blank spaces. Variable Name: %%DB-ACCOUNT
Database Type	Defines the type of database (read-only).
Execution Type	Determines the execution type of the Database job, as follows: Stored Procedure SQL Script Embedded Query Characters: 1-4096 SSIS package (MSSQL only) MSSQL Agent (MSSQL only) You can use additional databases to run the Execution Type. For more information, see Adding a Database Type. Variable Name: %%DB-EXEC_TYPE
More Options	Opens more attributes.
Enable auto Commit	Determines whether to commit statements that complete successfully to the database. Available for all execution types except SSIS. Variable Name: %%DB-AUTOCOMMIT
Append execution log to job output	Determines whether to show the execution log in the job outputA tab in the job properties pane in the Monitoring domain that shows the output of a job, which indicates whether a job ended OK, and used, for example, with jobs that check file location.
Append SQL output to job output	Determines whether to show the SQL output in the job output.
Output format	Determines whether to define the output format as either text, XML, CSV, or HTML.

Database Stored Procedure Attributes

The following table describes the Database Stored Procedure job attributes. Fields can contain 1–4096 characters.

Attribute	Description
Schema	Defines the Database schema that contains the Stored Procedure. Variable Name: %%DB-STP_SCHEM
Stored Procedure	Defines the Stored Procedure.
Parameters table	Lists the parameters of the Stored Procedure.
Name	Defines the name of the Stored Procedure parameter. Variable Names: %%DB-STP_NAME %%DB-SCRPT_NAME
Data Type	Defines the data type of the Stored Procedure, such as string or integer. Variable Name: %%DB-STP-PARAMS-Pnnn-PRM_TYPE
Parameter Type	Defines the variable name that stores the OUT and Return parameters result in the Stored Procedure submission. Variable Name: %%DB-STP_PARAMS-Pnnn-PRM_DIRECTION
Value	Defines the parameter values of the Stored Procedure and SQL script. Variable Names: %%DB-STP-PARAMS-Pnnn-PRM_VALUE %%DB-SCRPT-PARMS-Pnnn-VALUE
Variables	Defines the variables of the Stored Procedure. Variable Name: %%DB-SCRPT-PARMS-Pnnn-VARIABLE

The following table describes the Database SQL Script job attributes. Fields can contain 1–4096 characters.

Attribute	Description
File Name	Defines the file path of the SQL Script.
Script Variables	Defines an SQL script variable and its value.

The following table describes the Database SSIS Package job attributes (MSSQL only). Fields can contain 1–4096 characters.

Attribute	Description
Package Source	Defines the location of the SSIS Package in SQL Server, File System, or SSIS Package Store. Variable Name: %%DB-SSIS_PACKAGE_SOURCE
Package Name	Defines the name of the SSIS Package. Variable Name: %%DB-SSIS_PACKAGE_NAME
Environment	Defines the environment that an SSIS catalog runs on. Variable Name: %%DB-SSIS_CATALOG_ENV
SSIS Configuration File Names	Defines the names of the configuration files that are added to the SSIS package. Variable Name: %%DB-SSIS_CONFIGFILES-Nxxx-NAME
Properties Path	Defines the name of each SSIS property path. Variable Name: %%DB-SSIS_SETVALPARAMS-Nxxx-NAME
Value	Defines the values of each SSIS property path. Variable Name: %%DB-SSIS_SETVALPARAMS-Nxxx-VALUE

The following table describes the Database MSSQL Agent job attributes (MSSQL only). Fields can contain 1–4096 characters.

Attribute	Description
Job Name	Defines the name of MSSQL Agent Job, which was defined in MSSQL Server. Variable Name: %%DB-SSA_NAME
Category	Determines the category of the MSSQL Job. Variable Name: %%DB-SSA_CATEGORY_NAME

Attribute

Description

Job Name

Defines the name of MSSQL Agent Job, which was defined in MSSQL Server.

Variable Name: %%DB-SSA_NAME