I work with asp/ms sql.
I need to know how I can send email on specified date through my asp code and ms sql.
I need a sample script.
Can I use maybe sq triggers?how?
Send email automatically through ms sql server on specified date?
in order to send the mails on specified date, you should use "jobs" in sql server, just go to Enterprise Manager, under management, find SQL Server Agent and under that Jobs. You can set a job to fire on a specified date or recurring dates. This is the first part. Second part is to place the sql script to be executed when job runs. There is an sp in SQL called sp_sendmail. You can use it to send e-mails thoughout you sql server. Refer to Books OnLine
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment