January 19, 2012 at 10:44 am
I have a job that I get an email notification via DB Mail in SQL2005 and it works fine. My question is that another person wants to get an email that the job has completed and how long it took. In the GUI under NOTIFICATIONS you can only specify one persons email though. I have tried to script it out and modify it to have two email notifications but it appears that it will only accept one.
Is there anyway around this apparent limitation?
January 19, 2012 at 11:06 am
Would it work to set up an e-mail group with you and the other person in it, and send it to that group instead of one person?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 19, 2012 at 11:11 am
I thought about that but this is a one job only type deal. This person owns this job and simply wants to know when this job finishes and how long it takes. I was just going to put in a step to the job to send him an email but he kind of wants to know how long the job runs and if I can just add him it automatically shows the job duration.
January 20, 2012 at 6:23 am
Keep it simple. Add a final step to the job that sends an e-mail to him. Duration at that point should be easy to get from the msdb system tables.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply