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 |
|
manu
Starting Member
41 Posts |
 Posted - 2006-02-27 : 07:08:17
|
| Hi,i want to schedule a stored proceedure through a DTS Pack.Pls help me in doing the same.Munish |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2006-02-27 : 07:21:58
|
| HiExecute the procedure directly from a scheduled job. Create a new job, add a step of type 'Transact-SQL script' that executes your proc(e.g. 'EXEC dbo.MySProc @Param1 =1, etc.'), and schedule to run as desired.Mark |
 |
|
|
manu
Starting Member
41 Posts |
Posted - 2006-02-27 : 09:00:49
|
| thanks a lot Mark |
|
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2006-02-28 : 05:00:50
|
| No problem MunishMark |
|
|
|
|
|
|
scheduling execution of stored proceedure