asked on

sql server 2005 mail suddently stops but job succeeds

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
following message
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.

dbaSQL

If it worked before, and is suddenl failing, I would be curious about the actual job steps, and the full job log.

But, it almost looks like the @returnval output param is not being specified. Again, if this worked before and just stopped, that is a little puzzling, but if you're expecting output, you should store that in a local variable.

mngong_rc

ASKER

Would like to give all points to dbaSQL for attempting . Found an entirely newer and simple script on the web that works with a few mods . Not sure why the script started failing and have spent enough time on troubleshooting that I could have created a script from scratch

Thanks
MNT

ASKER CERTIFIED SOLUTION

dbaSQL

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial