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)
