Permissions required for "agent_job_failure" in SQL probe
search cancel

Permissions required for "agent_job_failure" in SQL probe


Article ID: 215287


Updated On:


CA Process Automation Base


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"]


Release : 4.3.X

Component : Process Automation


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

More information is also available here: