Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> pre-DST scheduler info - an idea
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-lReceived on Thu Mar 08 2007 - 12:42:37 CST