August 4, 2008 at 4:43 am
hi 🙂
This is Vasanthi,i am working as a developer in small organization.presently i am working on one job portal project.in this project i need to send some mails automatically.
for this i need to write a trigger for this.
means when the employer is posted any job if that job is expired in 7 days so we have to send an email alert to those employer from 7 days onwards,
for this i need a trigger.
how to write a trigger for sending a mail alert.
Please i need this urgently.
if any one knows about this plz give reply to this.
Thanking u in advance.:)
August 4, 2008 at 5:13 am
if that job is expired in 7 days so we have to send an email alert to those employer from 7 days onwards,
for this i need a trigger.
how to write a trigger for sending a mail alert.
Use sp_send_dbmail use send emails.
Create a SQL Server Agent job to check the date posted and send email if it is expired.
August 4, 2008 at 5:45 am
Use sp_send_dbmail use send emails.
Create a SQL Server Agent job to check the date posted and send email if it is expired.
Thanks for u r reply .:)
if u dont mind can us end me the total process for this and procedure.
y bcz i know how to create job in sql server agent but i dont know how to call that job and send a mail.
if u dont mine please send the whole process for this.
Thaking u in Advance.:)
August 4, 2008 at 6:53 am
but i dont know how to call that job and send a mail
Don't call the job. Schedule it to run at required interval.
See the BOL to know more about sp_send_dbmail. Very good examples are given.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply