how to write trigger based on certain condition

[psn]

One of my table called as 'customertable' contains following fields

customername, emailid, subscriptionendperiod

Example records are:

david, david@john.com, 12/20/2005(mm/dd/yyyy format).

My question is that: Just one month before subscriptionendperiod that is on 11/20/2005(mm/dd/yyyy) an automatic email should go to david@john.com with the message 'Your subscription period ends on 12/20/2005'

How to write trigger for this.

Please Note : No ASP code is invloved in this.
Only MSSQL coding to be done.


Regards

[skhanal]

A trigger can only be fired on a DML, so you can't get it to trigger based on current date. You can write a stored procedure and run that every day.

[MAK]

You have to schedule a job and a run the proc daily.

[MAK]

oops. Sailesh said the same thing. Ignore.