Hi,
the job of recycling agent error logs is failing.
Use MSDB
GO
EXEC dbo.sp_cycle_agent_errorlog
GO
The error I get is :-
Msg 22022, Level 16, State 1, Line 0
SQLServerAgent Error: The process cannot access the file because it is being used by another process.
I tried to see sql server logs and couldnt find anyhting related to this
In sql server agent error logs, it says: -
Message
[412] Errorlog has been reinitialized. See previous log for older entries.
Does that job succeded?
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP