4e7683aee2
Grosse mise à jour : - style moderne des tableaux et code - code structuré et factorisé - sql et sh affinés
14 lines
258 B
SQL
14 lines
258 B
SQL
prompt <h2>Failed scheduled jobs </h2>
|
|
|
|
select /* db-html-report */
|
|
OWNER,
|
|
JOB_NAME,
|
|
JOB_TYPE,
|
|
STATE,
|
|
TRUNC(START_DATE) SDATE,
|
|
TRUNC(NEXT_RUN_DATE) NXTRUN,
|
|
FAILURE_COUNT
|
|
FROM
|
|
DBA_SCHEDULER_JOBS
|
|
WHERE
|
|
FAILURE_COUNT <> 0; |