August 3, 2012 at 2:54 am
Hi
In our environment, sql server agent got stopped suddenly and could not get the proper info even from error log. Could you please let me know the reasons for this
August 3, 2012 at 4:09 am
have you checked sql agent error log?
xp_ReadErrorLog 0, 2, NULL, NULL
go
xp_ReadErrorLog 1, 2, NULL, NULL
post the results for this.
Regards
Durai Nagarajan
August 3, 2012 at 4:24 am
2012-07-29 04:22:37 - ! [382] Logon to server 'MLIVSDSDSSDBD\DSS' failed (ConnAttemptCachableOp)
2012-07-29 04:22:37 - ! [165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]
2012-07-29 04:22:37 - ! [382] Logon to server 'MLIVSDSDSSDBD\DSS' failed (ConnUpdateJobActivity_NextScheduledRunDate)
2012-07-29 04:22:37 - ! [165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]
2012-07-29 04:22:37 - ! [382] Logon to server 'MLIVSDSDSSDBD\DSS' failed (ConnAttemptCachableOp)
2012-07-29 04:22:37 - ! [165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]
2012-07-29 04:22:37 - ! [382] Logon to server 'MLIVSDSDSSDBD\DSS' failed (ConnAttemptCachableOp)
2012-07-29 04:22:38 - ! [165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]
2012-07-29 04:22:38 - ! [382] Logon to server 'MLIVSDSDSSDBD\DSS' failed (SaveAllSchedules)
2012-07-29 04:22:40 - ! [165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]
2012-07-29 04:22:40 - ! [382] Logon to server 'MLIVSDSDSSDBD\DSS' failed (DisableAgentXPs)
2012-07-29 04:22:40 - ? [098] SQLServerAgent terminated (normally)
August 3, 2012 at 5:24 am
check this link
Regards
Durai Nagarajan
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply