建Job

建job脚本，注意点是jobno这个变量的类型是pls_integer
declare
 jobno pls_integer;
begin
  sys.dbms_job.submit(job => jobno,
                      what => 'UpdateStatus;',
                      next_date => sysdate,
                      interval => 'add_months(trunc(sysdate,''mm''),1)');
  commit;
end;