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 |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2002-09-09 : 14:25:09
|
| I want to schedule a job to process a table immediately.It seems like job scheduling is setup for "scheduled" not immediate job execution.Does anyone know a job scheduleing trick that will start a job immediately?SamC |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-09-09 : 14:30:44
|
| Create the job and run it with sp_start_job. This will run a job regardless of its schedule settings. You can also right-click the job in Enterprise Manager and choose Start Job. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-09-09 : 18:46:51
|
| Why do you want it to process immediately?Can't you just run it from a query window?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
How to schedule a Job for immediate execution