In SAP Early Watch Alert report, below warning message appear,
DBCC Job not Scheduled! (CCMS Check Database)
There are a number of database maintenance jobs that should be scheduled
in order to alleviate troubleshooting and help with the administration
of your system. Some of these jobs are not scheduled.
Solution
Go to transaction code DB13 and schedule the Check Database Consistency job.
It is advisable to schedule the job outside business hour. In this example, we scheduled it to run at 1am every week on Saturday.
Note
- 142731 – SQL Server DBCC checks
- 2358112 – DBCC Job not Scheduled! in EWA Service Report
