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 |
|
ryanlcs
Yak Posting Veteran
62 Posts |
 Posted - 2009-10-26 : 03:42:19
|
| HiI wanted to schedule a job to keep on running non-stop. This job will actually monitor for a table constantly, if any data comes in, it will perform the script. I tried the "Starts automatically when SQL Server Agents start", but it is not a recurring job.And if I choose the recurring option, the minimum time frame to run the job is 1 minutes, which is too long of waiting.Any ideas? |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-10-26 : 04:21:36
|
| I think you may need to use a trigger on that tableMadhivananFailing to plan is Planning to fail |
 |
|
|
ryanlcs
Yak Posting Veteran
62 Posts |
Posted - 2009-11-22 : 21:19:06
|
| For some reason, trigger is not the best option for me. I want a schedule job to run "forever". |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-22 : 21:45:52
|
| what's the reason?if you must make it a sql agent job you can make multiple schedules, set them to run every minute, but 20 seconds apart.but really, why not a trigger? |
|
|
|
|
|
|
How to schedule a job 'non-stop'