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 |
|
sqlhelp14
Yak Posting Veteran
55 Posts |
 Posted - 2008-02-15 : 10:18:43
|
| I have to get email at 10am when job runs successfully daily at 10am which i did thru sql agent job and it shows job succeded at 10am last run...but i didn't get email...can anyone tell me should i have to use alert or should i have to write one condition in sproc...but i think its simple in job schedule i make it 10am daily and notifications - email if job succeed..but strange i m not recieving...can anyone have idea what will be the reason?thanks for ur help. |
|
|
Qualis
Posting Yak Master
145 Posts |
Posted - 2008-02-15 : 10:24:10
|
| Is this SQL Server 2005? If so, use the Notifications area of the Job. |
 |
|
|
sqlhelp14
Yak Posting Veteran
55 Posts |
Posted - 2008-02-15 : 10:36:47
|
| yes, its 2005 and i use notification area : in which email when job succeed...and job is runing successfully but i don't recieve email..don't no why? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-16 : 14:45:47
|
| Do you use sql mail or db mail? Was mail server working? |
|
|
|
|
|
|
sql agent job