How to schedule a DTS package using SQL Server Agent (Enterprise Manager)

How to Install SQL Server 2000

How To

How to schedule a DTS package using SQL Server Agent (Enterprise Manager)

To schedule a DTS package using SQL Server Agent

  1. In SQL Server Enterprise Manager console tree, expand Management, and then click SQL Server Agent.

  2. In the details pane, right-click Jobs, and then click New Job.

  3. On the General tab, complete the information to configure the new job.

  4. Click the Steps tab, click New, and then do the following:
    • In the Step name box, type a name.

    • In the Type list, click Operating System Command (CmdExec).

    • In the Command text box, type the dtsrun command for the package.

Note  Scheduled packages are run by SQL Server Agent and, as such, do not have the same shared drive letters or the same permissions as the package creator.

See Also

Scheduling a DTS Package for Execution