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 |
|
albertkohl
Aged Yak Warrior
740 Posts |
 Posted - 2012-04-11 : 17:05:55
|
| okay, so for some odd reason last night the server time got JACKED UP! i mean like it was 9pm and server thought it was 5am... so i fixed it when i came in this morning, and everything is good, however all of the mail that my server has been requested to send is still sitting in the UNSENT queue. when i run: exec msdb..sysmail_help_queue_sp @queue_type = 'Mail' i see that the last_empty_rowset and last_activated_time are about 5hrs into the future, i'm suspecting that's why the mail service hasnt delivered any new message. is there any way to reset these values? or is there something else i should do? any help would be greatly appreciated! |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2012-04-12 : 03:27:41
|
You could try update a sysmail table in msdb database, but this is not something I recommend.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
|
|
|
DB Mail Queue has Wrong Time