kknudson
SSCarpal Tunnel
Points: 4986
More actions
March 9, 2004 at 9:43 am
#83886
I have a job scheduled via SQLAgent, it failed with the error " Could not connect to server (local) ..."
The problem was it was being run in the wrong DB, just an mistake on my part. But the error message is strange.
it was a simple SQL statement
KlK
Steve Jones - SSC Editor
SSC Guru
Points: 728159
March 9, 2004 at 10:34 am
#498018
When a job starts, SQLAgent connects to SQL Server, just like you would with QA. If there's any hiccup, which sometimes can occur, the job fails. You can set a retry after a minute or so, might help to prevent this type of thing.
Follow me on Twitter: http://www.twitter.com/way0utwest Forum Etiquette: How to post data/code on a forum to get the best help My Blog: www.voiceofthedba.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply