February 19, 2009 at 7:35 am
I am writing a sql trigger where i need to update the time in every 2 hour in following table
id ScheduleTime
1 5:01 AM 1
2 5:05 AM 1
so after 2 hour it should be
id ScheduleTime
1 7:01 AM 1
2 7:05 AM 1
any ideas?
February 19, 2009 at 8:20 am
Why a Trigger and not a job?
Why even store that value if it can be calculated?
Can you be more specific on what are you trying to accomplish?
* Noel
February 19, 2009 at 8:22 am
A trigger won't really do that. Triggers are things that happen because of data events, limited to update, insert, delete statements, or DDL events, like creating or dropping objects.
If you need something to happen at a scheduled interval, you need a job, not a trigger.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply