SQL Jobs stop
-
Hello, About twice a month our sql server agent stops running all the jobs, till the server has been restarted. on checking the error log we found this message, approximately every 5 seconds in the log file till the time the server was re-started. Message [165] ODBC Error: 0, Memory allocation failure [SQLSTATE HY001] It fails on this job that takes about 12 hours to run. Any ideas on this error message? Thanks.
-
Hello, About twice a month our sql server agent stops running all the jobs, till the server has been restarted. on checking the error log we found this message, approximately every 5 seconds in the log file till the time the server was re-started. Message [165] ODBC Error: 0, Memory allocation failure [SQLSTATE HY001] It fails on this job that takes about 12 hours to run. Any ideas on this error message? Thanks.
This may be unrelated but check your maximum memory. We had a problem where sql server quit running and it was because the memory was set to the default which meant sql took all the memory and the OS had none.
-
Hello, About twice a month our sql server agent stops running all the jobs, till the server has been restarted. on checking the error log we found this message, approximately every 5 seconds in the log file till the time the server was re-started. Message [165] ODBC Error: 0, Memory allocation failure [SQLSTATE HY001] It fails on this job that takes about 12 hours to run. Any ideas on this error message? Thanks.
As barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.