Hi,
Today when i execute EXEC sp_cycle_sqlagent_errorlog, got the below error and each time i execute this one of the log file gets deleted.
It was in maintainance plan and because of this our routine full backups job failed.
Now there was only one Current Agent log file was left,cant see any of the physical file in the location where the logs were stored.
Can I add the log files again? Why it has got deleted? Actually they should recycle but they wasnt.
Failed:(-1073548784) Executing the query "EXEC msdb.dbo.sp_cycle_agent_errorlog" failed with the following error: "SQLServerAgent Error: 32.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:EXEC msdb.dbo.sp_cycle_agent_errorlog
Can anyone pl help me with this?