Creating a job scheduled based on a specific timezone I have an Oracle database hosted in Europe. I need to create a scheduled job in the database to send email. I need to send email daily at 17:30:00 in India standard time (IST).

I know how to send email and create jobs. But don't know how to create a job to execute on my local time (IST).

How can I do this?
The following creates a job to execute daily at 17.30 local time specified by country.

BEGIN
  DBMS_SCHEDULER.CREATE_JOB (
   job_name           =&gt;  'update_sales',
   job_type           =&gt;  'STORED_PROCEDURE',
   job_action         =&gt;  'OPS.SALES_PKG.UPDATE_SALES_SUMMARY',
   start_date         =&gt;  '07-AUG-13 17.30.00 PM India/Delhi',
   repeat_interval    =&gt;  'FREQ=DAILY',
   end_date           =&gt;  '07-AUG-14 17.30.00 PM India/Delhi',
   auto_drop          =&gt;   FALSE,
   job_class          =&gt;  'batch_update_jobs',
   comments           =&gt;  'My new job');
END;
/