I have scheduled a job that calls a stored procedure function:
The job works but I cannot see the status of the job when I right click on the Job name under Jobs menu:
The error says:
ORA-01882: timezone region %s not found.
I created the job as in the attached code.
Do I need to update the code in Job?
I attached the error screen-shot.
DBMS_SCHEDULER.CREATE_JOB(job_name => 'MyJobName',
job_type => 'STORED_PROCEDURE',
job_action => 'MyProc.myFunc',
start_date => to_timestamp_tz('02/16/2011 21:00:00 US/Central',
'mm/dd/yyyy hh24:mi:ss tzr'),
repeat_interval => 'FREQ=daily',
enabled => true,
auto_drop => false,
comments => 'My table refresh');