I am getting the following error message for both Data warehousing Load Data and Access Rights.
Is there a way to update this Jobs not Alter Databases?
ClarityDB - isOracle? - An error occurred executing this job entry :
Couldn't execute SQL: DECLARE @V_DBNAME VARCHAR(100);
SELECT @V_DBNAME = DB_NAME();
EXEC ('ALTER DATABASE ' + @V_DBNAME + ' SET RECOVERY BULK_LOGGED;');
EXEC CMN_SAVEDROP_CREATE_MVIEWS_SP 'DWH_SEC_UNIT_BY_MODE', 'SAVE_DROP';
[CA Clarity][SQLServer JDBC Driver][SQLServer]The operation cannot be performed on database "PPM_DWH_DEV" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group.
Any help is greatly apppreciated
thank you,
Somio
------------------------------
Somi
------------------------------