Can I make a trigger that is fired every x hours?
A:
No, Triggers are dependent upon rows being inserted, updated or deleted. The only way that you could have a trigger fire every few hours is to create a separate table and insert a row every few hours. shahkalpesh is correct, this was not the intended functionality for a trigger
bogertron
2009-08-05 22:08:37
+2
A:
If you are using SQL Server you can use SQL Server Agent for doing repetitive jobs.
Jenea
2009-08-05 22:11:51