How to schedule a DTS package using the SQLServerAgent service

To schedule a DTS package using the SQLServerAgent service

  1. Expand a server; then expand a server group. In the SQL Server Enterprise Manager console tree, expand Management; then click SQL Server Agent.
  2. Right-click Jobs, and then click New Job....
  3. Complete the information on the General tab of the New Job Properties dialog box, and then click the Steps tab.
  4. Click New..., and then complete the information in the General tab of 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.

(c) 1988-98 Microsoft Corporation. All Rights Reserved.