DEPRECATED: Starting with SSIS+ 1.9, the .NET scripts are no longer maintained. Use the provided JavaScript alternative scripts instead.
Script File:
Overview
Script task providing basic manipulation operations for SQL Agent Jobs. You can enable, disable, start, stop or drop a Job. You can also check if job is enabled or the running status of the job.
Setup
The script has the following parameters:
- Connection - SQL Server connection manager (Connection).
- IsJobVariable - if true, Job name is contained in package variable. Otherwise it is explicitly specified (String).
- JobVariable - package variable containing Job name (String).
- Job - Job selection (String).
- Action - action the task performs.
- ResultVariable - package variable where result is stored.
- JobStep - optional parameter for StartJob action. Step from, which to start execution.
Requirements
Depends on Microsoft SQL Management Objects (SMO) for Job manipulation.
Depends on COZYROC Script Task Plus for implementing parameters user interface.