this is what iwant to do

[prasadbuddhika]

in the database i have a table for complains and to solve the complain 24hrs are given.if the time is expired i want to db to generate an E-mail and send it to manager . i'm planning to do this by using a trigger. if it is possible to do how to impliment this other wise could you please suggest how to do it ,:)

[John ph]

Trigger's are probably used against a database operation like Insert, Update, Delete. Not when a job is failed. Why not try with Sql Server Agent and the extended stored procedure xp_sendmail. Sql server has the ability to send mail without being triggered from the application. you can set up a job through Sql Server agent that wakes up and check's at proper intervals whether any job is failed and if yes then send's email. Regards John

[Burnsys2]

i have a dedicated table "Emails" with columns: "From","To","Subject","Text" The table has trigger on insert that calls a xp_sendmail Any time i need to send an email fron anywhere all i have to do is insert a record in that table!