Hi,
A silly question...
I had created a job where the timezone is in Australia/Sydney,Now they need it in CST. So instead of Australia/Sydney should I just replace it with the term CST?Will it be correct?
or anything else is needed?
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'update_sales',
job_type => 'STORED_PROCEDURE',
job_action => 'OPS.SALES_PKG.UPDATE_SALES_SUMMARY',
start_date => '28-APR-16 07.00.00 PM Australia/Sydney',
repeat_interval => 'FREQ=DAILY;
end_date => '20-NOV-17 07.00.00 PM Australia/Sydney',
auto_drop => FALSE,
job_class => 'batch_update_jobs',
comments => 'My new job');
END;
/