sql server 2005 mail suddently stops but job succeeds
Posted on 2011-09-08
Have sql server 2005 configured to send out an email when space used falls below a certain threshold .
Test emails work properly . Have checked the sql server agent mail profile accordingly
but job still fails.
Thanks for any help
Job log below
This worked for a while and suddenly stopped working . The jobs still succeeds with the
Source: ODSOLE Extended Procedure [SQLSTATE 01000] (Message 0) Description: sp_OAMethod usage: ObjPointer int IN, MethodName varchar IN [, @returnval <any> OUT [, additional IN, OUT, or BOTH params]] [SQLSTATE 01000] (Message 0). The step succeeded.