Permissions required for "agent_job_failure" in SQL probe

Products

• CA Process Automation Base

Issue/Introduction

On enabling the "agent_job_failure" parameter we have received below alert and we need to know what kind of access is required to resolve this. As of now, we have sysadmin account created for database and on test connection for the mentioned instance the connection is OK.

["Profile: 1234/agent_job_failure/Run Query - DB Provider: Code=0x0x80040e09 Source=Microsoft OLE DB Provider for ODBC Drivers Description=[Microsoft][ODBC SQL Server Driver][SQL Server]The SELECT permission was denied on the object 'syscategories', database 'msdb', schema 'dbo'."] Alerts from : ["1234"],  UIMHUB is ["HUBU01"]  probetype ["sqlserver"]

Environment

Release : 4.3.X

Component : Process Automation

Resolution

The DBA will need to grant the Probe user access to the system tables noted in the SQL documentation:

https://docs.microsoft.com/en-us/sql/relational-databases/system-tables/system-tables-transact-sql?view=sql-server-ver15

More information is also available here:

https://docs.microsoft.com/en-us/sql/t-sql/statements/grant-system-object-permissions-transact-sql?view=sql-server-ver15