Home » RDBMS Server » Enterprise Manager » Some scheduled jobs are not showing on EM Cloud Control 12c R3 (OEM Cloud Control 12.1.0.3 on 11.2.0.4 DB on RedHat Linux)
Some scheduled jobs are not showing on EM Cloud Control 12c R3 [message #617179] Wed, 25 June 2014 13:50 Go to next message
Lucky A
Messages: 57
Registered: October 2007
Member
Hi All,

I am running 11.2.0.4 database on RedHat Linux and my scheduled jobs are on OEM Cloud Control 12.1.0.3 owned by SYSMAN. The jobs have been consistent in performance but as of last week, three of the many jobs didn't run. When investigated, the scheduled jobs are not showing on Cloud Control I tried to recreate it, thinking someone may have deleted it in error but I got the message "A job with the specified name already exists Please provide a different name". When I query the MGMT_VIEW.MGMT$JOBS, I can see that the jobs exist.
1) Where are the jobs
2) How do I locate them on Cloud Control
3) How do I get the jobs to run at the scheduled date?

Thanks,

Lucky
Re: Some scheduled jobs are not showing on EM Cloud Control 12c R3 [message #617180 is a reply to message #617179] Wed, 25 June 2014 13:52 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
>1) Where are the jobs
in the cloud

>2) How do I locate them on Cloud Control
ask cloud control where they are

>3) How do I get the jobs to run at the scheduled date?
fix the problem


Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/

Re: Some scheduled jobs are not showing on EM Cloud Control 12c R3 [message #617244 is a reply to message #617180] Thu, 26 June 2014 08:13 Go to previous messageGo to next message
Lucky A
Messages: 57
Registered: October 2007
Member
The jobs have run consistently as scheduled but as of last week, three of the many jobs didn't run and are not running. When I investigated, the scheduled jobs are not showing on Cloud Control. I tried to recreate it, thinking it may have been deleted in error but I got the message "A job with the specified name already exists Please provide a different name". When I query the MGMT_VIEW.MGMT$JOBS, I can see that the jobs exist in the database.

How can I get the job to show up on Cloud Control and also how do I get it to run repeatedly as scheduled?

Thanks
Re: Some scheduled jobs are not showing on EM Cloud Control 12c R3 [message #617245 is a reply to message #617244] Thu, 26 June 2014 08:20 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
fix the problem

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/
Re: Some scheduled jobs are not showing on EM Cloud Control 12c R3 [message #617266 is a reply to message #617245] Thu, 26 June 2014 10:01 Go to previous messageGo to next message
Lucky A
Messages: 57
Registered: October 2007
Member
If I am wrongly posting my request or missing something, please correct me.

I am running Oracle 11.2.0.4 database on Red Hat Enterprise Linux Server release 5.10.
The jobs are on OEM Cloud Control 12.1.0.3 running as SYSMAN.
The jobs have run consistently but as of last week, some of jobs didn't run
and are not showing up on Cloud Control.
Enterprise -> Job -> Activity -> "Advanced Search"
=> Owner ( All) Status ( All) Scheduled Start (Last 7 Days) -> GO
Shows no display of the jobs that failed to run,
but there's display of the last successful run and none of the next scheduled run.

I tried to recreate the missing jobs but I got the error message:
'A job with the specified name already exists Please provide a different name'.

When I query the database, all of the jobs are displayed:
select job_owner,job_name from MGMT_VIEW.MGMT$JOBS order by 1,2;
How can I get the job to show up on Cloud Control and also how do I get it to run repeatedly as scheduled?

Thanks,
Lucky
Re: Some scheduled jobs are not showing on EM Cloud Control 12c R3 [message #617278 is a reply to message #617266] Thu, 26 June 2014 12:20 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
SELECT error#, 
       Count(*) 
FROM   dba_scheduler_job_run_details 
GROUP  BY error#; 
Re: Some scheduled jobs are not showing on EM Cloud Control 12c R3 [message #617281 is a reply to message #617278] Thu, 26 June 2014 13:30 Go to previous message
Lucky A
Messages: 57
Registered: October 2007
Member
Below is the result:

SQL> SELECT error#,
Count(*)
FROM dba_scheduler_job_run_details
GROUP BY error#; 2 3 4

ERROR# COUNT(*)
---------- ----------
0 758202
Previous Topic: Oracle 11g RAC EM rebuilding failed.
Next Topic: Missing tablespaces menu option from Enterprise Manager
Goto Forum:
  


Current Time: Sun Sep 21 11:46:43 CDT 2014

Total time taken to generate the page: 0.05114 seconds