EM12c: Job Step Scheduler is shown as down – EM jobs remain in scheduling indefinitely

Problem:

EM12c: Job Step Scheduler is shown as down – EM jobs remain in scheduling indefinitely and don't run

Change made:

Upgrade to Rel 3 12.1.0.3 and apply DB Plugin 12.1.0.5

The repository job called “Job Step Scheduler” is shown as down on Management Services and Repository Page.

Go to Setup > Manage Cloud Control > Repository

In Repository Scheduler Jobs Status section, the "Job Step Scheduler" job is shown as down with a red arrow.

All the other jobs look good and are running successfully.

So, found this metalink note, and applied the same logic

EM 12c : After Upgrade to R2 12.1.0.2 Repository Job Purge Is Shown As Down on Management Services And Repository Page (Doc ID 1496431.1)

SQL>  select dbms_jobname from mgmt_performance_names where display_name = 'Job Step Scheduler';

 EM_JOB_OBSERVER.run_cycle

SQL>  select job from all_jobs where what='EM_JOB_OBSERVER.run_cycle'

 no rows selected

 SQL>  select count(*) from all_jobs

 0

SQL> select owner, job_name, job_action, enabled, state, failure_count, last_start_date, last_run_duration

from dba_scheduler_jobs where job_name LIKE 'EM_JOB%'

SYSMAN              EM_JOB_PURGE_POLICIES         EM_JOB_PURGE.APPLY_PURGE_POLICIES();      TRUE     SCHEDULED        0                08-MAY-14 05.07.11.883712000 AM -05:00            0 0:0:17.949089

SYSMAN              EM_JOBS_STEP_SCHED                EM_JOB_OBSERVER.run_cycle  FALSE    DISABLED            0              24-JAN-14 06.29.08.570318000 PM EST5EDT               0 0:0:0.013817

I can see the job is disabled.

I will enable it

SQL>  BEGIN

      sys.dbms_scheduler.enable(name=>'"SYSMAN"."EM_JOBS_STEP_SCHED"');

END;

SQL>  select owner, job_name, job_action, enabled, state, failure_count, last_start_date, last_run_duration

from dba_scheduler_jobs where job_name LIKE 'EM_JOB%'

SYSMAN              EM_JOBS_STEP_SCHED                EM_JOB_OBSERVER.run_cycle  TRUE     SCHEDULED        0              24-JAN-14 06.29.08.570318000 PM EST5EDT               0 0:0:0.013817

SYSMAN              EM_JOB_PURGE_POLICIES         EM_JOB_PURGE.APPLY_PURGE_POLICIES();      TRUE     SCHEDULED        0                08-MAY-14 05.07.11.883712000 AM -05:00            0 0:0:17.949089

The job is now scheduled.

Will also update mgmt._performance_names

SQL>  UPDATE MGMT_PERFORMANCE_NAMES

 SET display_name = NULL,dbms_jobname = NULL, is_dbmsjob = 'N', is_deleted = 'Y'

 WHERE UPPER(DBMS_JOBNAME) LIKE 'EM_JOB_OBSERVER.RUN_CYCLE';

1 row updated

SQL>  COMMIT;

Now checking the status of the job shows to be up.

The jobs run successfully again.

References

EM 12c : After Upgrade to R2 12.1.0.2 Repository Job Purge Is Shown As Down on Management Services And Repository Page (Doc ID 1496431.1)

EM 12c: The EM Jobs Service Target is Shown with Down Status in the Enterprise Manager 12.1.0.2 Cloud Control Console (Doc ID 1589084.1)