RE: Oracle 10 Grid Dbms Jobs

From: <Joel.Patterson_at_crowley.com>
Date: Wed, 13 Sep 2006 09:01:29 -0400
Message-ID: <02C2FA1C9961934BB6D16DE35707B27B02054004@jax-mbh-01.jax.crowley.com>

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_at_crowley.com
x72542
904 727-2542

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mercadante, Thomas F (LABOR)
Sent: Wednesday, September 13, 2006 8:27 AM To: oracle-l_at_freelists.org
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.  

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 13 2006 - 08:01:29 CDT