OraFAQ Forum: Enterprise Manager » Some scheduled jobs are not showing on EM Cloud Control 12c R3

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Some scheduled jobs are not showing on EM Cloud Control 12c R3 [message #617179]

Wed, 25 June 2014 13:50

Lucky A
Messages: 68
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

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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/

Report message to a moderator

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

Lucky A
Messages: 68
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

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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/

Report message to a moderator

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

Lucky A
Messages: 68
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

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SELECT error#, 
       Count(*) 
FROM   dba_scheduler_job_run_details 
GROUP  BY error#;

Report message to a moderator

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

Lucky A
Messages: 68
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

Report message to a moderator

Previous Topic:	Oracle 11g RAC EM rebuilding failed.
Next Topic:	Missing tablespaces menu option from Enterprise Manager

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 16:40:50 CST 2024