Enterprise Edition
Customer Service

Brother-Eagle Community

  • Visit/Join Now!
  • Get tips from other users!
  • Share your own tips, advice, and metric formulas!

DBI Products

Brother-Eagle™ Oracle Performance
Advice: # Broken Jobs

This parameter indicates the number of Oracle jobs that are broken. This is determined by querying the DBA_JOBS view:

Select count(*) from dba_jobs where broken = 'Y';

Broken jobs can't be good and should be addressed by those responsible for the job. The DBA_JOBS view provides additional information that may help the DBA pinpoint ownership of the job.


View full list of Oracle advice topics