The Datamart Extraction job fails with errors below in BG log:
Caused by: java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]The SELECT permission was denied on the object
'sysjobs_view', database 'msdb', schema 'dbo'.
This error has also been seen on some scenarios:
"The Server Principal "NIKU" is not able to access the database "msdb" under the current security context"
Release: Clarity PPM 15.8 and supported releases
The SQL Server Management Studio tool can be used to add the Clarity administrator account to the SQLAgentUserRole role by using the following steps: