Share via

How to: Create an ActiveX Script Job Step (SQL Server Management Studio)

This topic describes how to create and define a Microsoft SQL Server Agent job step that executes an ActiveX script.

To create an Active Script job step

  1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.

  2. Expand SQL Server Agent, create a new job or right-click an existing job, and then click Properties.

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

  3. In the Job Properties dialog, click the Steps page, and then click New.

  4. In the New Job Step dialog, type a job Step name.

  5. In the Type list, click ActiveX Script.

  6. In the Run as list, select the proxy account with the credentials that the job will use.

  7. Select the Language in which the script was written. Alternatively, click Other and then enter the name of the Microsoft ActiveX scripting language in which the script will be written.

  8. In the Command box, enter the script syntax that will be executed for the job step. Alternately, click Open and select a file containing the script syntax.

  9. Click the Advanced page to set the following job step options: what action to take if the job step succeeds or fails, how many times SQL Server Agent should try to execute the job step, and how often retry attempts should be made.