How to send automatic alerts??
-
I am in need of writing an application ,as soon as i deployed an application in asp.net server it has check automatically a column of a table depending the value i have to send emails on daily basis(that means when a day changes it has to automatically scan the entire table based on that it has to send emails..)please help me out in this matter
-
I am in need of writing an application ,as soon as i deployed an application in asp.net server it has check automatically a column of a table depending the value i have to send emails on daily basis(that means when a day changes it has to automatically scan the entire table based on that it has to send emails..)please help me out in this matter
Use windows scheduler.
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
-
I am in need of writing an application ,as soon as i deployed an application in asp.net server it has check automatically a column of a table depending the value i have to send emails on daily basis(that means when a day changes it has to automatically scan the entire table based on that it has to send emails..)please help me out in this matter
Hi, You can schedule triggers on database based on time condition. Or You can execute a function that check the current date value after a specified time period and if old date and new date is not equal then you can execute your code. Regards Atul.
-
I am in need of writing an application ,as soon as i deployed an application in asp.net server it has check automatically a column of a table depending the value i have to send emails on daily basis(that means when a day changes it has to automatically scan the entire table based on that it has to send emails..)please help me out in this matter
y u cant go for scheduled tasks? i acheived using that
Thanks & Regards, Member 3879881, please don't forget to vote on the post
-
I am in need of writing an application ,as soon as i deployed an application in asp.net server it has check automatically a column of a table depending the value i have to send emails on daily basis(that means when a day changes it has to automatically scan the entire table based on that it has to send emails..)please help me out in this matter
If your database is SQL Server, I would create a SQL Agent job that runs on a schedule to scan the table. Then you can use database mail to send the emails.
My other signature is witty and insightful.