tags:

views:

74

answers:

3

Can I make a trigger that is fired every x hours?

+5  A: 

That is what Scheduled Jobs are for.
See if this helps.

shahkalpesh
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
+2  A: 

If you are using SQL Server you can use SQL Server Agent for doing repetitive jobs.

Jenea