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 |
|
kxd11
Starting Member
4 Posts |
 Posted - 2014-07-01 : 15:56:12
|
| Under Management -> Jobs, I had created a backup job to backup a certain database and setup the operator to be notify when the job is completed ( Between 7am - 7pm). I will get the notification at 7, 8 & 9 o'clock but at 10 o'clock I don't receive a notfication or at 9, 10 ,11,12 o'clock I will get a notification but at 1:00 I won't receive on. There is no pattern And I'm check to see if there is a conflict with another process running. Any ideals would be appreciated. Thank you. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-07-01 : 16:03:01
|
| use msdbgoselect * from sysmail_allitemsselect * from sysmail_event_logselect * from sysmail_logselect * from sysmail_faileditemsTara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
kxd11
Starting Member
4 Posts |
Posted - 2014-07-01 : 16:38:28
|
| This is on a SQL 2000, those select statments works on 2008. |
|
|
|
|
|
|
SQL Mail (Notification)