Answers for "oracle job"

SQL

job oracle exemple

BEGIN
    DBMS_SCHEDULER.CREATE_JOB(
      job_name => '"MYSCHEMA"."JOB_NAME"',
      job_type => 'STORED_PROCEDURE',
      job_action => 'MYSCHEMA.PROCEDURE',
      number_of_arguments => 0,
      start_date => to_timestamp_tz(
        '2021-04-08 14:19:32.000000000 EUROPE/PARIS', 
        'YYYY-MM-DD HH24:MI:SS.FF TZR'),
      repeat_interval => 
      'FREQ=DAILY;BYDAY=MON,TUE,WED,THU,FRI;BYHOUR=12;BYMINUTE=30;BYSECOND=0',
      end_date => NULL,
      enabled => FALSE,
      auto_drop => FALSE,
      comments => 'Job description');

    DBMS_SCHEDULER.enable(
            name => '"MYSCHEMA"."JOB_NAME"');
END;

Posted by: Guest on August-27-2021

Source

oracle job session

-- Get Job session IDs
SELECT jr.JOB, s.USERNAME, s.SID, s.SERIAL#, p.SPID, s.LOCKWAIT, s.LOGON_TIME
FROM DBA_JOBS_RUNNING jr, V$SESSION s, V$PROCESS p
WHERE jr.SID = s.SID AND s.PADDR = p.ADDR
ORDER BY jr.JOB;

Posted by: Guest on April-21-2021

oracle job class

SELECT JOB_CLASS_NAME,
       RESOURCE_CONSUMER_GROUP,
       SERVICE,
       LOGGING_LEVEL,
       LOG_HISTORY,
       COMMENTS
FROM DBA_SCHEDULER_JOB_CLASSES
ORDER BY JOB_CLASS_NAME;

Posted by: Guest on September-03-2021

Source

Code answers related to "oracle job"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

Answers for "oracle job"

Code answers related to "oracle job"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us