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 - 2001-02-12 : 01:24:09
|
| Ralph writes "I have a stored procedure that is run from a SQLAgent job every 60 seconds. It works well and reliably. Trouble is I need to schedule the job more often, approximately every 10 seconds. Job/SP checks an input table and processes new arrivals unless automatically turned off while doing heavy db maintenance. The Job Scheduler won't go any faster than 1/minute. Any ideas??" |
|
|
|
|
|
Scheduling a job more often than Once per mintue