Action Types
The action type defines what type of operation will be performed. Variable-type actions create a user-defined variable for use throughout the job.
| Action Type | Description |
|---|---|
| Variable/SQL | Set a variable through the execution of a SQL SELECT statement run against the Destination database. Set the variable value equal to the first column of the first row returned by the statement. |
| Variable/VBScript | Set a variable through the execution of a custom VBScript function. A shell function is provided called “ScriptedVariable”, the value of the variable will be what is returned out of the function. |
Variable/C# | Set a variable through the execution of a custom C# function. A shell function is provided called “ScriptedVariable()”, the value of the variable will be what is returned out of the function. |
Variable/JavaScript | Set a variable through the execution of a custom JavaScript function. A shell function is provided called “scriptedVariable()”, the value of the variable will be what is returned out of the function. |
| Execute SQL | Execute any kind of statement against the Destination database. Useful for calling DELETE or UPDATE statements before or after a job for cleanup purposes. |
| VBScript Procedure | Execute any statements desired in a VBScript Sub. A shell sub called “VBScriptProcedure” is provided. Any kind of VBScript processing can be called here. Useful for before-job file manipulation, or any kind of pre- or post-processing. |
C# Procedure | Execute any statements desired in a C# Sub. A shell sub called “ CSharpProcedure()” is provided. Any kind of C# processing can be called here. Useful for before-job file manipulation, or any kind of pre- or post-processing. |
JavaScript Procedure | Execute any statements desired in a JavaScript Sub. A shell sub called “jsProcedure()” is provided. Any kind of JavaScript processing can be called here. Useful for before-job file manipulation, or any kind of pre- or post-processing. |
Xref Write | Writes to the selected Xref List given the provided old ID and new ID. |