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 |
|
skillile
Posting Yak Master
208 Posts |
 Posted - 2002-06-05 : 22:00:39
|
| Whats the best way to have a stored procedure runautomatically? Should you call it from DTS, script itagain in DTS. I'm not sure what is best practice. The event is going to be a table update 3-4 times dailyif that matters.If any code is available, it would be appreciated.Thanksslow down to move faster... |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-06-05 : 22:17:28
|
| No need for DTS at all. Create a new job in Enterprise Manager (under Management:SQL Agent:Jobs) and add a job step to it. Type should be T-SQL, and just put in EXECUTE spName in the code window. Then set the schedule on the schedule tab. |
 |
|
|
skillile
Posting Yak Master
208 Posts |
Posted - 2002-06-05 : 22:18:57
|
| thanks, exactly what I needed. Didn't know you could call the sprocI was retyping it in and I knew it should be easier.slow down to move faster... |
|
|
|
|
|
|
AutoRun Stored Proc