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 |
|
OMB
Yak Posting Veteran
88 Posts |
 Posted - 2004-03-08 : 04:37:26
|
| Hi All Is there any way that you can schedule a job to run every two seconds, currently the default in EM is every minute.ThanxsOMB |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-03-08 : 05:25:34
|
| Not directly. There are a few ways you could handle this, and you're not going to like either of them (I really don't like one of them).The first one, which I think would bring pain, is to write a wrapper proc that called a worker procedure then did a WAITFOR to pause for a second and put it in a loop.The other one is to have your scheduling process external to SQL Server, either in a service, a script or a running executable.The nicest way, would be to write a windows service in VB.NET or C# that fired off your job every few seconds.The benefit there is that if it all goes wrong you don't have horrible looping code running inside your SQL Server so your box won't die.Damian |
 |
|
|
OMB
Yak Posting Veteran
88 Posts |
Posted - 2004-03-08 : 05:54:52
|
| Cheers Damiancurrently using the first method, agree not the best way, I found some TSQL that can do it but again not very clean, came to the same conclusion will need to create a external app to do the proccessing.OMB |
|
|
|
|
|
|
Schedule Jobs