March 9, 2004 at 9:43 am
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
March 9, 2004 at 10:34 am
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy