Return
-
Title
SQL jobs are failing. The logs say "{process name} was successfully marked for recompilation." -
Description
SQL jobs are failing to process. The log contains the following info, e.g.:
"DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) Object 'AADBaseTreeHasDeniedService' was successfully marked for recompilation. [SQLSTATE 01000] (Message 15070) Object 'AADBaseTreeHasDirectoryRole' was successfully marked for recompilation. [SQLSTATE 01000] (Message 15070) Object 'AADBaseTreeHasGroup' was successfully marked for recompilation... The step failed."
-
Cause
The database needs to be compiled. -
Resolution
Compile the database using the Database Compiler.