November 25, 2009 at 1:15 am
Hi guys,
I've been working as DBA for quite a while now but I admit I'm not quite an expert on it yet. That's why I'd like to ask for your ideas and opinions regarding this error I see on a job I have here. I don't know what could be the cause for this and neither do I know how to troubleshoot this error since everytime I try to manually run the job after it fails, it'll succeed. The job is scheduled to run every 2PM along with other jobs that seems to run quite perfectly. There are days also that this job runs successfuly. Here is the error detail:
SendStatement: GenerateReport: Cannot open SQL server. [SQLSTATE 42000] (Error 50000). The step failed.
The job runs a stored procedure residing on the same SQL instance.
Hope you could help me resolve this issue or pinpoint the cause of the problem guys.
Thanks!
<hr noshade size='1' width='250' color='#BBC8E5'>Regards,
Neil
November 25, 2009 at 1:18 am
Do you see anything in the sql logs, and is there anything else running at this time.
What does the stored procedure do, and has anything changed recently, regarding accounts or permissions
you have also posted this in the sql 7, 2000 forums, i take it is a sql 2005 problem
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
November 25, 2009 at 1:54 am
I don't see any errors on the SQL log and the job is used to send email notification to customers regarding their account.
<hr noshade size='1' width='250' color='#BBC8E5'>Regards,
Neil
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply