How to schedule a DTS package using the SQLServerAgent service
To schedule a DTS package using the SQLServerAgent service
- Expand a server; then expand a server group. In the SQL Server Enterprise Manager console tree, expand Management; then click SQL Server Agent.
- Right-click Jobs, and then click New Job....
- Complete the information on the General tab of the New Job Properties dialog box, and then click the Steps tab.
- 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.