in sql server 2005 i need to send e mails periodically.
-
through my db i want send e-mails periodically,but i don't know to perform this task periodically . how can i do this ?
-
through my db i want send e-mails periodically,but i don't know to perform this task periodically . how can i do this ?
Using db you can not send the mail periodically. But this method will help you. Create an excutable file which contains sending mail code. Schedule this excutable file using windows scheduler from control panel. Now your executable file will check the pending mails from your db and will send the mail. Once mail is sent then set the flag sent so that it will not sent again.
-
through my db i want send e-mails periodically,but i don't know to perform this task periodically . how can i do this ?
Have you considered using SQL Server Agent?