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 |
|
ssnaik84
Starting Member
15 Posts |
 Posted - 2009-04-01 : 11:32:10
|
| Hi,Is it possible to write time based triggers?We have a website running on a web hosting company, which does not provide access to schedular or windows service.We need some tasks to be performed automatically, on regular intervals.I am looking for alternative to windows scheduler, on database side.Thanks in adv. |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-04-01 : 11:44:38
|
| How about creating a job on their SQL server under your database. if not create a bogus table with a trigger then create an event on your website that inserts into that table? maybe?<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
|
|
|
time based trigger or stored procedure