|
|
|
|
|
The following table describes the parameters for a Databases Job:
NOTE: Take into consideration that some parameters might not appear in your properties pane, if they were not specified in the User View you applied. Use Control-M rules if the parameter rules were not specified by the Site Standard.
Parameter |
Description |
|---|---|
Connection Profile |
Defines the name of the Control-M for Databases connection profile. Control-M rules:
|
Execution Type |
Defines the database Job as a stored procedure, SQL Script, SSIS package, or Open Query. |
Auto Commit |
Commits statements that complete successfully to the database. It is available for all execution types except for SSIS. |
Query |
Defines the database Job as an Embedded Query Job. Control-M rule: 1-4096 characters |
Schema |
Filters stored procedures results according to schema names. Control-M rule: 1-4096 characters |
Package |
Filters stored procedures results according to package names. Control-M rule: 1-4096 characters |
Name |
Defines the name of the stored procedure. Control-M rule: 1-4096 characters |
Parameter Name |
Defines the names of the stored procedure parameters. Control-M rule: 1-4096 characters |
Value |
Defines the parameter values of the store procedure and SQL script. Control-M rule: 1-4096 characters |
Auto-Edit Variable
|
Defines the variable name that stores the OUT and Return parameters result in stored procedure submission. Control-M rule: 1-4096 characters |
Variable |
Defines the variables of the SQL Script. Control-M rule: 1-4096 characters |
Query text |
Defines the content of the SQL Script. Control-M rule: 1-4096 characters |
Data Type |
Defines the data type of the stored procedure, such as string or integer. Control-M rule: 1-4096 characters |
Parameter Type
|
Defines the stored procedure column type as IN or OUT. Control-M rule: 1-4096 characters |
Append log to sysout |
Shows the execution log in the Job output. |
Append output to sysout |
Shows the output in the Job output. |
Select output format |
Defines the output format as either text, XML, CSV, or HTML. |
Package Source |
Defines the location of the SSIS Package in SQL Server, File System, or SSIS Package Store. |
Package Name |
Defines the name of the SSIS Package. Control-M rule: 1-4096 characters |
Environment |
Defines the environment that an SSIS catalog runs on. |
SSIS Configuration File Names |
Defines the names of the configuration files that are added to the SSIS package. Control-M rule: 1-4096 characters |
SSIS Parameter Names |
Defines the name of each SSIS property path. Control-M rule: 1-4096 characters |
SSIS Parameter Values |
Defines the values of each SSIS property path. Control-M rule: 1-4096 characters |
Job Name |
Defines the name of MSSQL Agent Job, which was defined in MSSQL Server. Control-M rule: 1-4096 characters |
Category |
Determines the category of the MSSQL Job. Control-M rule: 1-4096 characters |
Parent Topic |