January 17, 2007 at 8:06 am
OK, I had a fellow DBA ask me about this one and I have little idea as to what could be causing this one so I could really use your guys help.
Problem Details
Have a job witth one step that runs xp_sendmail with some parameters...
EXEC xp_sendmail
@Recipients ='Lind, Sherry J',
@Subject ='WIP pallet receipt exceptions',
@Query ='ImpactProdRept.dbo.sp_WIPGetReceiptDateExceptions',
@Attach_Results ='false',
@Width =500
The job does not throw a failure but looking at the job history displays the following...
Executed as user: sa. ODBC error 4604 (42000) There is no such user or group 'sa8'. [SQLSTATE 01000] (Message 18014). The step succeeded.
A Weird thing about the error messages is the 'sa8' changes randomly...one time it could be 'sa0', next time 'sa4'...ect.
OTHER INFORMATION.
1. Account that is logged into the server is the same account that runs both services and is a Domain account.
2. I can run the above query in QA and it works just fine.
3. Box is a SQL 2000 SP3 and I cannot change the SP.
4. The Domain account is in the Admins list for local admins on the box.
I have searched all over Google and cannot find anything that even hints as to what to look at or investigate...
if anyone has any recomendations I would love to hear them...
Thanks In Advance,
Lee
January 18, 2007 at 8:12 am
Reboot of the server cleaned up the mess...apparently one of the others felt that would fix the problem and it did.
So all it was is a memory problem 😐
January 18, 2007 at 9:11 am
I doubt it was memory. There can be problems using mapi mail if the exchange server restarts and you don't then stop and restart the sql server. It's not always .. I never figured a more elegant solution though.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
January 18, 2007 at 8:54 pm
Huh...I never thought of stopping and restarting the mail...would have been something to troubleshoot it further...
I guess I didn't even think about it because I could put the xp_sendmail in query analyzer and run the mail successfully...just not via a job.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply