Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Time conversion in oracle DBA scheduler

Gayathri VenugopalMay 23 2016 — edited May 31 2016

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;

/
This post has been answered by S Paul RJ on May 23 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 28 2016
Added on May 23 2016
#database-key-features, #plsql, #scheduler
18 comments
5,152 views