Create a trigger to send email notification

Hello experts, I would like to send an email notification to an employee when their car mileage has been approved, but I don't know if this can be done using a trigger.

I have a table CAR_MILEAGE_CLAIM and when the field MGR_APPROVED is updated to 'Yes' i would like to send an email notification to the employee, the email address is in the field EMPLOYEE_EMAIL

Here's what I'd like the email to be: (microsoft outlook 2000)

To: [EMPLOYEE_EMAIL]
Subject: Car Mileage Confirmation & Date
Body: I can add blurb later


Thanks, DomiLama
DomiLamaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Eugene ZConnect With a Mentor Commented:
check examples:
Implementing Triggers in SQL Server 2000
by Navneeth Diwaker Naik
http://www.sql-server-performance.com/nn_triggers.asp

----
CREATE TRIGGER

http://msdn2.microsoft.com/en-us/library/aa258254(SQL.80).aspx
----
xp_sednmail

http://msdn2.microsoft.com/en-us/library/aa260697(SQL.80).aspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.