Create, Run, Stop, enable, disable, and Drop a Job
How to create the
job....?
=====================================================================================
SYSDBA> GRANT CREATE JOB TO scott;
scott@test >
BEGIN
sys.dbms_scheduler.create_job(job_name => 'P_UPD',
job_type => 'PLSQL_BLOCK',
job_action => 'begin
scott.P_UPD_UID;
end;',
repeat_interval => 'FREQ=DAILY;BYHOUR=19;BYMINUTE=00;BYSECOND=0',
start_date => sysdate,
job_class => 'DEFAULT_JOB_CLASS',
comments => 'P_UPD',
auto_drop => FALSE,
enabled => TRUE);
END;
/
PL/SQL procedure successfully
completed.
=====================================================================================
SYSDBA> conn SCOTT/tiger@test
show user
BEGIN
sys.dbms_scheduler.create_job(job_name => 'FILE_UPLOAD',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN
SCOTT.upload_wrapper;
END;',
repeat_interval
=> 'FREQ=DAILY;BYHOUR=19;BYMINUTE=00;BYSECOND=0',
start_date =>
sysdate,
job_class => 'DEFAULT_JOB_CLASS',
comments => 'FILE_UPLOAD',
auto_drop =>
FALSE,
enabled =>
TRUE);
END;
/
=====================================================================================
SCOTT@test1 >
BEGIN
sys.dbms_scheduler.create_job(job_name => 'DAS_UPLOAD',
job_type =>
'PLSQL_BLOCK',
job_action => 'BEGIN
DAS_UPLOAD;
END;',
repeat_interval => 'FREQ=DAILY;BYHOUR=23;BYMINUTE=00;BYSECOND=0',
start_date =>
sysdate,
ob_class =>
'DEFAULT_JOB_CLASS',
comments =>
'DAS_UPLOAD',
auto_drop => FALSE,
enabled => TRUE);
END;
/
=====================================================================================
scott@rcc1 > BEGIN
sys.dbms_scheduler.create_job(job_name => 'FILE_UPLOAD',
job_type => 'PLSQL_BLOCK',
job_action => 'begin
ADS.eADS_upload_wrapper;
end;',
repeat_interval => 'FREQ=DAILY;BYHOUR=21;BYMINUTE=0;BYSECOND=0',
start_date => sysdate,
job_class => 'DEFAULT_JOB_CLASS',
comments => 'eADS_upload_wrapper',
auto_drop => FALSE,
enabled => TRUE);
END;
/
PL/SQL procedure successfully
completed.
===========================E=N=A=B=L=E==J=O=B======================
SYSDBA> exec
DBMS_SCHEDULER.ENABLE ('ADS.EADS_UPLOAD'); ---- For enabling the given job
===========================D=I=S=A=B=L=E==J=O=B====================
SYSDBA> exec
DBMS_SCHEDULER.DISABLE ('SCOTT.FILE_UPLOAD',FALSE); -----------------> if
job is not running
SYSDBA> exec
DBMS_SCHEDULER.DISABLE ('SCOTT.FILE_UPLOAD',TRUE); ------------------> if
job is running
==========================D=R=O=P==J=O=B===========================
SYS@RCC1 AS SYSDBA> exec
dbms_scheduler.drop_job (job_name=>'SCOTT.FILE_UPLOAD'); ----------> for dropping a job
============================================================================
Q) how to run the job
manually...?
Note -> If the job is disable even though you can run the job
manually.
===============================================================================
SQL>
begin
dbms_scheduler.run_job (job_name
=> 'REFRESH_ER',use_current_session => false);
end;
/
PL/SQL procedure successfully
completed.
SQL>
begin
dbms_scheduler.run_job (job_name
=>'TOP_MAX',use_current_session => false);
end;
/
SQL>
begin
dbms_scheduler.run_job (job_name
=>'TOP_UPLOAD',use_current_session => false);
end;
/
=======================================================
No comments:
Post a Comment