SQL> select dbtimezone from dual;
DBTIME
-06:00
SQL> select dbms_scheduler.stime from dual;
STIME
14-FEB-07 12.03.09.969269000 PM -05:00
my job es el siguiente
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => ‘telefonica’,
job_type => ‘STORED_PROCEDURE’,
job_action => ‘siafmef.telefonica’,
repeat_interval =>’freq=weekly; byday=mon,wed,fri; byhour=07; byminute=30; bysecond=00′,
start_date => ‘=’14-FEB-07 07.30.00 AM -05:00’,
comments => ‘My new job’);
END;
y corre a las 2:30.. y como vez esos son os GMT de mi base de datos
a nivel de server
sql>!date
SQL>Wed Feb 14 12:11:23 EST 2007