Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
akpaga
Constraint Violating Yak Guru
331 Posts |
 Posted - 2010-07-19 : 13:49:43
|
| Hi friends i have table with a datetime field in it. a job that runs each day and updates the table . So when the job updates the last record(updates datetime field) , a trigger should initiate that sends a db mail saying the job has completed ... How can i achieve this?thank you in advance |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
akpaga
Constraint Violating Yak Guru
331 Posts |
Posted - 2010-07-19 : 15:47:08
|
| hi tkizer..sorry my previous psot msilead you..actuall its an classic asp appliaction that does the updates..by job i di not mean sql server job it was an asp apllication...sorry for that |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
akpaga
Constraint Violating Yak Guru
331 Posts |
Posted - 2010-07-19 : 17:26:48
|
| thanks for the input tkizer. i will check if the asp application iteslef can do the job of sending email once it completes. |
|
|
|
|
|
|
trigger after the last record is updated