Oracle job启动及停止

--启动

VARIABLE job NUMBER;
begin
sys.dbms_job.submit(job => :job,
what => 'dmpac_gu_action.trance_job_action();',
next_date =>sysdate,
interval => null);
commit;
end;
/ 

--停止

select * from dba_jobs;
select * from dba_jobs_running ;

select 'ALTER SYSTEM KILL SESSION ''' || s.sid || ',' || s.SERIAL# || ''';'
  from v$session s, v$process p
 where s.paddr = p.addr and s.sid = '417';
 
exec dbms_job.broken(493,true);
exec dbms_job.remove(493);
commit;