one time dba scheduler job creation

 PROCEDURE proc_oo_mst_xml_export_cntrl(p_rowid varchar2)

as

v_cnt number;

begin

select count(1) into v_cnt from user_scheduler_running_jobs;

If nvl(v_cnt,0) < 50 then

del_xml_oo_mst(p_rowid);

dbms_scheduler.create_job

   (

     job_name      =>  'OTJ_REQ_'||to_char(SYSTIMESTAMP,'yyyyMMddhh24missFF'),

     job_type      =>  'PLSQL_BLOCK',

     job_action    =>  'begin proc_oo_mst_xml_export('''||p_rowid||'''); end;',

     start_date    =>   sysdate,

     enabled       =>  TRUE,

     auto_drop     =>  TRUE,

     comments      =>  'one-time job');

     commit;

End if;

end;