changing the timing in scheduler jobs
Hi All,
In the below code I have given the execution timing as 2:15. But next run date value is showing as 3:00 AM. What is wrong here?. I created this job at 2:00 AM
SQL> select owner,LAST_START_DATE,NEXT_RUN_DATE from dba_Scheduler_jobs where JOB_NAME='job2' and owner='owner1';
OWNER LAST_START_DATE NEXT_RUN_DATE
-------------------- -------------------- ------------------------------
owner1 08-DEC-12 03.00.00.000000 AM -
05:00
SQL> BEGIN
2 DBMS_SCHEDULER.create_job (
3 job_name => owner1.job2',
4 job_type => 'PLSQL_BLOCK',
5 job_action => job2();',
6 start_date => '08-Dec-12 2.15.00AM',
7 repeat_interval => 'freq=hourly; byminute=0; bysecond=0;',
8 end_date => NULL,
9 enabled => TRUE,
10 comments => 'None');
11 END;
12 /