How to schedule a DTS package using SQL Server Agent (Enterprise Manager)
To schedule a DTS package using SQL Server Agent
- In SQL Server Enterprise Manager console tree, expand Management, and then click SQL Server Agent.
- In the details pane, right-click Jobs, and then click New Job.
- On the General tab, complete the information to configure the new job.
- 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.
- In the Step name box, type a name.
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.