How to schedule a DTS package using the SQLServerAgent service (Enterprise Manager)

How to schedule a DTS package using the SQLServerAgent service (Enterprise Manager)

To schedule a DTS package using the SQLServerAgent service

1. Expand a server, and then expand a server group.
   
   
2. Expand Management, and then expand SQL Server Agent.
   
   
3. Right-click Jobs, and then click New Job.
   
   
4. Complete the information on the General tab, and then click the Steps tab.
   
   
5. Click New, and then complete the information in the New Job Step dialog box:
   • For Type, click Operating System Command (CmdExec) from the list.
     
     
   • For Command, enter the dtsrun command for the package.
     
     
   • Click the Advanced tab for further job customization options.

See Also

How to create a job (Enterprise Manager)