trigger to send an email 30 days prior to a due date.

[Kennrosie]

I am using visual studio.net.

I want the system to send an email 30 days prior to a due date.

Example:

Employee Performance due date: 12 Dec 2005

I would like the system to generate an email to the supervisor on 12 Nov. 2005

I have not found any material on how to perform this function.

 

[ca8msm]

You could have a timer that checked each day (using the interval property) if it was due to send an email and if it is then send it. I'd probably do it in a service though.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[abs2003]

How are you determine due date? Do you use SQL database to store employee and due date? If you do then you can query the due date where it will be 30 days up. Then you can call Stored procedure that will send out the email.

Look up "xp_sendmail" in SQL Online Help.

You also need to look into Windows Service to automated the application.

Let me know if you need a sample code for Stored Procedure

 

[SBendBuckeye]

Hello abs2003,

I'd be interested in your stored proc code if you don't mind sharing it.

Have a great day!

j2consulting@yahoo.com