DBMS_Scheduler Modify Time zone
Hi ,
I have created a job using DBMS_SCHEDULER with named schedule.
After modified the schedule using the below queries,
exec dbms_scheduler.disable( 'JOB1' );
exec dbms_scheduler.set_attribute_null('JOB1','schedule_name');
exec DBMS_SCHEDULER.SET_ATTRIBUTE( name => 'JOB1', attribute => 'repeat_interval', value => 'freq=WEEKLY;BYDAY=SUN,WED,FRI;BYHOUR=04');
exec dbms_scheduler.enable( 'JOB1' );
Using the client system to change the setting and the time zone differs from that of production. Even though the job is scheduled to run at 4 PM it show the start date as 3:30 AM which is the client system time.
I have created a job using DBMS_SCHEDULER with named schedule.
After modified the schedule using the below queries,
exec dbms_scheduler.disable( 'JOB1' );
exec dbms_scheduler.set_attribute_null('JOB1','schedule_name');
exec DBMS_SCHEDULER.SET_ATTRIBUTE( name => 'JOB1', attribute => 'repeat_interval', value => 'freq=WEEKLY;BYDAY=SUN,WED,FRI;BYHOUR=04');
exec dbms_scheduler.enable( 'JOB1' );
Using the client system to change the setting and the time zone differs from that of production. Even though the job is scheduled to run at 4 PM it show the start date as 3:30 AM which is the client system time.
0