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 |
|
missMac
Posting Yak Master
124 Posts |
 Posted - 2008-10-17 : 06:01:58
|
| Hello Guys,has MS SQL got any function or program that has an execution timer. Apart from SQL Jobs ?In Visual basic, there is an a timer function that allows you to run specific functions at specific times.I read up about service broker. But has MS SQL got any timer execution functions to do this ?thanks |
|
|
cvraghu
Posting Yak Master
187 Posts |
Posted - 2008-10-17 : 06:17:39
|
| Please explain in detail what are you trying to achieve. Generally jobs are used for scheduling such works. |
 |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-10-17 : 06:49:22
|
| You could create job in script and delete on completion. Use sp_add_job to create job and set @delete_level=1 to delete job on completion. You can combine this with a work table which is filled e.g. by application. You can set a trigger on table to create new job for each new row then delete job and row in table already processed. |
|
|
|
|
|
|
Start Execution Timer