Oracle JOB

  /**1.***/
  create or replace procedure apps.sp_createtab_tbl_status authid current_user as
  tabname varchar(200);
begin
  select 'apps.TBL_STATUS_' || to_char(sysdate, 'yyyymmddhhmiss')
    into tabname
    from dual;
  execute immediate 'create table ' || tabname ||
                    ' tablespace APPSD as select * from WFR.WFR_BILL_STATUS where 1 != 1';
  commit;
end;
/

/***2***/
VARIABLE testjobid number;
begin
  sys.dbms_job.submit(:testjobid,
                      'sp_createtab_tbl_status;',
                      TRUNC(sysdate,'mi') + 1/ (24*60),
                      TRUNC(sysdate,'mi') + 1/ (24*60));
commit;
end;

begin
dbms_job.run(1);
end;
select * from dba_jobs_running

/**3*****/

 

select * from v$bgprocess;