Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> pre-DST scheduler info - an idea

pre-DST scheduler info - an idea

From: Barbara Baker <barb.baker_at_gmail.com>
Date: Thu, 8 Mar 2007 11:42:37 -0700
Message-ID: <47a6f72b0703081042u6d6e6fdci7bf561559a980d0@mail.gmail.com>


FWIW . . .
I'm thinking it might not be a bad idea to capture our current dbms_job and dbms_scheduler jobs into a text file pre-DST so we can compare them with post-DST

Here's what I'm gathering:
dbms_job
  select * from dba_jobs

dbms_scheduler
  select * from

  dba_scheduler_jobs
  dba_scheduler_job_run_details
  dba_scheduler_programs
  dba_scheduler_program_args
  dba_scheduler_job_log
  dba_scheduler_running_jobs
  dba_scheduler_schedules

I'm tossing in output from this stmt as well:

select to_timestamp_tz('20070311 00:00:00 US/EASTERN','YYYYMMDD HH24:MI:SS TZR') + to_dsinterval('0 08:00:00') TEST from dual;

Is anyone collecting any other info??
Barb

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 08 2007 - 12:42:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US