Description:
Scheduler jobs are the automated process handled by the database scheduler in oracle.
It will run the scheduler jobs in a specific server time intervals like daily , weekly and any periodically.
We need to create the Job under the schema which is owner of the calling objects.
We can also see the job ran status in a database level.
Job Creation:
This sample job is created and running for Daily morning 8 O clock.
Login as the database user which need to create the job.
conn san/***
connected.
Run the following script for create and schedule the job,
Begin
Sys.DBMS_SCHEDULER.create_job
(job_name => ‘JOB NAME’,
job_type => ‘PLSQL_BLOCK’,
start_date => SYSDATE,
repeat_interval => ‘FREQ=DAILY; BYHOUR=08; BYMINUTE=00;’,
end_date => Null,
enabled => True,
job_action => ‘Declare
A varchar2(10);
B varchar2(10);
C Varchar2 (10);
begin select instance_name into C from v$instance;
then
<CONDITION>
Example condition: SCHEMA NAME.PACKAGE_NAME.CONDITION(PARAMETER);
end if;
END;’
);
End;
/
PL/SQL procedure successfully completed.
To know the job run details:
We have dba views for see the job details and job run details.
1.dba_scheduler_jobs
2.dba_scheduler_job_run_details
Thank you.