I am getting the following error when trying to run a scheduled job with the SQL Agent.
Executed as user: OHWEB\sqlserver. ConnectionCheckForData (CheckforData()). [SQLSTATE 01000] (Message 10054) General network error. Check your network documentation. [SQLSTATE 08S01] (Error 11). The step failed.
I am running a sql statement to clean up some tables and run's fine through query analyzer.
All this is running on the same server and the standard SQL install. Not sure why there would be a network error when it's not running accross the network. Any help would be appreciated.
Running SQL2k on Win2k Server. Latest patches on both.