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 |
|
djokerss
Starting Member
28 Posts |
 Posted - 2006-09-27 : 12:22:20
|
| i've made an application that need update data as long as server is running....i'd like to make update data with a store procedure that call every 1 minute...how can i run that store procedure as service ... so it dont need callwith my application....or is there another way to make it ?Note : the proses that i want is to counting when a job start untill its finished.There is a condition that the job is paused or stop temporary when it out of time work.Thanks before |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-27 : 12:28:11
|
| Just execute the stored procedure as a SQL Server Agent job. Schedule it to run every minute.Tara Kizer |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-09-27 : 12:28:18
|
you can schedule your stored procedure to run every minute via the Enterprise Manager
KH |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-09-27 : 12:31:15
|
KH |
|
|
|
djokerss
Starting Member
28 Posts |
Posted - 2006-09-27 : 12:34:12
|
| is there server agent for MSSQL 2005 EXPRESS ? |
|
|
|
|
|
|
running SP as service