Stack Overflow
Stack Overflow

Questions tagged [dbms-scheduler]

An Oracle scheduling package.

dbms_scheduler is an Oracle scheduling package, which provides methods of scheduling single jobs or groups of jobs at regular intervals or based on a calendar.

Questions tagged should also be tagged .

Further reading:

213 questions
-1
votes
2 answers

Scheduler event in Oracle

I have an event scheduler in mysql which is executing fine CREATE event 'STORE' ON schedule every 1 hour doUPDATE c_store SET is_active = '0' WHERE web_id = ( SELECT web_id FROM c_web WHERE …
User
  • 11
  • 1
-2
votes
1 answer

WHY THIS ORACLE DBMS_SCHEDULER JOB IS ONLY EXECUTED ONCE?

I have an Oracle job defined as follows: BEGIN DBMS_SCHEDULER.CREATE_JOB( JOB_NAME => 'DBMS_JOB_RESYNC_REQUESTS', JOB_TYPE => 'PLSQL_BLOCK', JOB_ACTION => ' BEGIN -- iterate over implicit cursor FOR K IN…
Moises Ahumada
  • 1
-3
votes
2 answers

Run a query based on weekends in oracle

am new to ORACLE; please help Am trying to run a query which pulls up records based on dates; if date is monday the query should run thrice; that is for monday, sunday, saturday (previous days also) for others days (tue to thursday only for same…
Vidhya Thanasingh
  • 11
  • 1
1 2 3
…
14
15