March 7, 2008 at 2:37 am
Hi All,
I have to check registration end date with system date,if it is getting expired then trigger should raise saying that your registration end date is expired and do u wish to renewal it r not. And mail should be sent to comapny email.
please could anyone help me out in writing trigger.
Regards,
Vinay.
March 7, 2008 at 9:44 am
a "trigger" in SQL Server (and other RDBM systems I know) is fired on a database action like insert, update or delete.
I think your problem looks more like a batch job since you probably want to identify expired accounts without requiring an insert/update to fire the SQL trigger.
If my understanding is correct then you might consider creating a SQL Agent job to run periodically to query for expiring accounts and do the needful.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply