How to create an Active Script job step (Enterprise Manager)

How to Install SQL Server 2000

How To

How to create an Active Script job step (Enterprise Manager)

To create an Active Script job step

  1. Create a new job or right-click an existing job, and then click Properties.

    For more information on creating a job, see Creating Jobs.

  2. Click the Steps tab, and then click New.

  3. In the Step name box, enter a job step name.

  4. In the Type list, click ActiveX Script.

  5. In the Language list, click a scripting language, or click Other and then enter the name of the Microsoft® ActiveX® scripting language in which the command will be written.

  6. In the Command box, enter the source for the job step.

  7. Click Parse to check your syntax.

    The message "Parse succeeded" is displayed when your syntax is correct. If an error is found, correct the syntax before continuing.

Note  There are some instances in which the "Parse succeeded" message is displayed, but the command does not run successfully. To determine whether the command will run successfully, run the command in an ActiveX script authoring environment such as Microsoft Visual Basic®.