Need to fix the broken jobs
Please assist me in resolving the broken jobs issue.
SQL> select job,LAST_DATE,BROKEN,FAILURES,TOTAL_TIME from dba_jobs;
JOB LAST_DATE BRO FAILURES TOTAL_TIME
---------- ----------------------------- --- ---------- ----------
61 Y 16 1
82 04-DEC-2013 16:28:00 N 0 34
88 04-DEC-2013 15:59:42 N 0 1250
90 03-DEC-2013 23:56:25 N 0 125
87 04-DEC-2013 16:26:19 N 0 24327
84 04-DEC-2013 16:28:00 N 0 13990
83 04-DEC-2013 14:59:41 N 0 43
62 Y 16 0
63 Y 16 2
81 04-DEC-2013 11:55:11 N 0 3048
85 03-DEC-2013 02:15:35 N 0 608626
JOB LAST_DATE BRO FAILURES TOTAL_TIME
---------- ----------------------------- --- ---------- ----------
86 03-DEC-2013 17:21:19 N 0 164099
89 04-DEC-2013 16:24:29 N 0 9112
13 rows selected.
SQL> select what from dba_jobs where job=61;
WHAT
----------------------------------------------------------------------------------------------------
begin l_stats_rollup1_proc; end;
SQL> select what from dba_jobs where job=62;
WHAT
----------------------------------------------------------------------------------------------------
begin l_stats_rollup2_proc; l_Purge_Stat2_proc; purge_usage_stat_proc; end;
0