Errors for the Execute permission on agent_datetime object similar to the following appear in the SQL Server log file for numerous collections such as
ERROR [AGENTNAME-lowPriorityPool-2-[DBSS_Replication_Agents][]] com.quest.qsi.fason.core.collection.processor.InstanceProcessor - Failed to run DBSSReplicationAgentsProcessor processor of DBSS_Replication_Agents collection.
java.lang.RuntimeException: Failed to execute collection [DBSS_Replication_Agents], reason=[Foglight][SQLServer JDBC Driver][SQLServer]Error Number 229 at Replication Agents Script.
Error Message: The EXECUTE permission was denied on the object 'agent_datetime', database 'msdb', schema 'dbo'. Profile:MSSQLProfile{host='HOSTNAME', instance= 'DEFAULT_INSTANCE', username='DOMAIN\USERNAME'
and
ERROR [AGENTNAME-lowPriorityPool-1-[DBSS_Agent_Job_List][]] com.quest.qsi.fason.core.collection.processor.InstanceProcessor - Failed to run DBSSAgentJobListProcessor processor of DBSS_Agent_Job_List collection.
java.lang.RuntimeException: Failed to execute collection [DBSS_Agent_Job_List], reason=[Foglight][SQLServer JDBC Driver][SQLServer]The EXECUTE permission was denied on the object 'agent_datetime', database 'msdb', schema 'dbo'