RE: Oracle 10 Grid Dbms Jobs

  • From: <Joel.Patterson@xxxxxxxxxxx>
  • To: <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 13 Sep 2006 09:01:29 -0400

For what it's worth... I didn't install it.

 

 

WHAT                                               NEXT_DATE
INTERVAL

-------------------------------------------------- -------------------
---------------------------------------

EMD_COLLECTION.RUN_COLLECTIONS();                  09/13/2006 09:01:12
sysdate + (1/(24*60))

EMD_LOADER.ROLLUP();                               09/13/2006 09:48:04
sysdate + (1/24)

EMD_NOTIFICATION.CHECK_FOR_SEVERITIES();           09/13/2006 09:00:46
sysdate + (1/(24*60))

EM_PING.MARK_NODE_STATUS();                        09/13/2006 09:01:13
sysdate + (1/(24*60*2))

EM_SEVERITY_REPOS.EXECUTE_REPOS_SEVERITY_EVAL();   09/13/2006 09:00:46
sysdate + 1 / (24 * 60)

MGMT_JOB_ENGINE.apply_purge_policies();            09/13/2006 09:48:27
sysdate + 1

emd_maintenance.analyze_emd_schema('SYSMAN');      09/14/2006 03:10:00
trunc(sysdate + 1) + 3/24 + 10/60/24

EMD_RT_ROLLUP.ROLLUP();                            09/13/2006 09:48:04
sysdate + (1/24)

EMD_E2E_ROLLUP.ROLLUP();                           09/13/2006 09:48:04
sysdate + (1/24)

EMD_BCN_AVAIL.EMD_EXEC_BEACON_AVAIL();             09/13/2006 09:00:46
sysdate + (1/1440)

EM_PURGE.APPLY_PURGE_POLICIES();                   09/14/2006 00:00:00
trunc(sysdate + 1)

 

 

Joel Patterson 
Database Administrator 
joel.patterson@xxxxxxxxxxx 
x72542 
904  727-2542 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mercadante, Thomas F
(LABOR)
Sent: Wednesday, September 13, 2006 8:27 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Oracle 10 Grid Dbms Jobs

 

All,


Can someone please run the following sql connected as SYSMAN in Grid
control on your machine and pass the result back to me?  Some idiot who
is writing this email changed the schedule that gets installed with grid
control without taking notes.  Just trying to make sure it is correct
now.

 

Column what format a50

Column interval format a30

Set lines 132

Set pages 50

select  what, to_char(next_date,'mm/dd/yyyy hh24:mi:ss')
next_date,interval

from user_jobs;

 

 

Thanks


Tom

 

 

________________________________

This transmission may contain confidential, proprietary, or privileged
information which is intended solely for use by the individual or entity
to whom it is addressed.  If you are not the intended recipient, you are
hereby notified that any disclosure, dissemination, copying or
distribution of this transmission or its attachments is strictly
prohibited.  In addition, unauthorized access to this transmission may
violate federal or State law, including the Electronic Communications
Privacy Act of 1985.  If you have received this transmission in error,
please notify the sender immediately by return e-mail and delete the
transmission and its attachments. 

 

Other related posts: