|
albertkohl
Aged Yak Warrior
USA
723 Posts |
 Posted - 04/11/2012 : 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! |
|
DB Mail Queue has Wrong Time
