Our Requirement is status field in the Database if the Status is false then Fetch all False List for the table And Alert mail go to 24 Hour .
After 24 hour again fetch the Record which status is false find all record and mail alert automatically send given mail id.
Any one help me.
Thanx in advance for help.
Loading
Gohil JayendrasinhPosted Oct 2, 2012, 9:11 AM
You can do this using SQL Server and Windows Service.
1) Create SQL JOB and check the status periodically
And send mail using Database mail functionality.
2) Create Windows Service and check the status
And send mail.
Second option is good because using this you can send
Mail using Template .