Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-05-10 : 07:56:46
|
| thariq writes "How do i execute a DTS package as a Job" |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-05-10 : 08:41:46
|
If you take a look in BOL it says quote:
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.
A sarcasm detector, what a great idea. |
 |
|
|
|
|
|
DTS Package