Oracle 10 Grid Dbms Jobs
- From: "Mercadante, Thomas F \(LABOR\)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 13 Sep 2006 08:26:55 -0400
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:
