Connection Profile

Defines the name of the Control-M for Databases connection profile.

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.

Schema

Filters stored procedures results according to schema names.

Package

Filters stored procedures results according to package names.

Name

Defines the name of the stored procedure.

Parameter Name

Defines the names of the stored procedure parameters.

Value

Defines the parameter values of the store procedure and SQL script.

Auto-Edit Variable

Defines the autoedit name that stores the OUT and Return parameters result in stored procedure submission.

Variable

Defines the variables of the SQL Script.

Query text

Defines the content of the SQL Script.

Data Type

Defines the data type of the stored procedure, such as string or integer.

Parameter Type

Defines the stored procedure column type as IN or OUT.

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.

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.

SSIS Parameter Names

Defines the name of each SSIS property path.

SSIS Parameter Values

Defines the values of each SSIS property path.