Solved

sql server 2005 mail suddently stops  but job succeeds

Posted on 2011-09-08
3
457 Views
Last Modified: 2012-05-12
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.
0
Comment
Question by:mngong_rc
  • 2
3 Comments
 
LVL 17

Expert Comment

by:dbaSQL
ID: 36504685
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.
0
 

Author Comment

by:mngong_rc
ID: 36524477
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
0
 
LVL 17

Accepted Solution

by:
dbaSQL earned 500 total points
ID: 36524540
Glad to hear you got things resolved.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to enforce inte 8 52
SQL Date from a string 4 65
Testing connection to sql 7 60
SQL Encryption question 2 56
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question