Thanks Kruzgoth. So I’ve managed to download the agent output as the error was occuring and compared it to the output when it is working.
No error messages and all the mssql sections are listed in both files at the topish.
The only difference is there is no data for the following sections lower in the output for when the error occurs:
<<<mssql_backup:sep(124)>>>
<<<mssql_transactionlogs:sep(124)>>>
<<<mssql_datafiles:sep(124)>>>
<<<mssql_databases:sep(124)>>>
<<<mssql_connections>>>
So it seems for whatever reason that the agent isn’t seeing any databases for these brief periods of time but I can’t nail down why. No related messages recorded in the SQL Server log.
cheers
jc