Open topic with navigation

Learn more about Toad for SQL Server
at Dell Software

Find solutions and downloads at the
Toad for SQL Server Support Portal

Toad for SQL Server 6.6

Create Job Steps

This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To create a job step

  1. Select Jobs from the Agent node in the Object Explorer.

  2. Click , and select the Steps page.

  3. Click New to create a job step.

  4. Complete the fields as necessary.  Review the following for additional information:

    Type

    Select the type of job step to execute. Available options are:

    • Transact-SQL Scripts (T-SQL)—Executes T-SQL batches.

    • ActiveX Script—Executes ActiveX scripts written in Visual Basic, Java Script, or any supported ActiveX script language.

    • Operating System (CmdExec)—Executes any commands or programs that have extensions ending with .bat, .cmd, .com, or .exe.

    • Replication Distributor—Executes the Distribution Agent automatically, if a distribution job was created.
    • Replication Transaction-Log Reader—Executes the Log Reader Agent automatically, if a log reader job was created.
    • Replication Merge—Executes the Merge Agent automatically, if a merge job was created.
    • Replication Queue Reader—Executes the Queue Reader Agent automatically, if a queue reader job was created.
    • Replication Snapshot—Executes the Snapshot Agent automatically, if a snapshot job was created.
    Options

    Specify the following options.

    Note: Available fields vary based on the type of job step you select.

    Database

    Select the database on which this job step executes.

    Output filename

    		Enter or browse for the path and name of the output file when the job step executes.

    Overwrite mode

    		If you selected an existing file, select whether this job step overwrites data in the file, or is appended to the end of the file.

    Run as user

    		Select the username you want to run this job step under.

    Script Language

    Select the scripting language used for the ActiveX script. If the correct language does not display, select Other and enter the name of the scripting language in the field.

    Exit code

    Enter a value for the exit code that returns if the command executes successfully. Valid values range from 0 to 999999.

 

Related Topics

About Jobs

Define Job Properties

About Job Steps

Set Advanced Job Step Options

of