Oracle Job

--创建对帐单的相关信息

 

DECLARE

 

  n NUMBER;

 

BEGIN

 

  BEGIN

 

    SELECT job

 

      INTO n

 

      FROM user_jobs

 

     WHERE what =

 

           'BEGIN ztenet.zte_sie_cb_pkg.send_bills_mail;ztenet.zte_sie_cb_pkg.hurry_bills_mail; end;';

 

  EXCEPTION

 

    WHEN OTHERS THEN

 

      n := 0;

 

  END;

 

  IF n > 0 THEN

 

    dbms_job.remove(n);

 

  END IF;

 

  -- Call the procedure

 

  sys.dbms_job.submit(n,

 

                      'BEGIN ztenet.zte_sie_cb_pkg.send_bills_mail;ztenet.zte_sie_cb_pkg.hurry_bills_mail; end;',

 

                      to_date(to_char(SYSDATE,'yyyy-mm-dd')||' 22:00:00','yyyy-mm-dd hh24:mi:ss'),

 

                      'SYSDATE + 1');

 

  COMMIT;

 

END;

/

/*

 

--查询

 

SELECT job, what, next_date, next_sec, failures FROM user_jobs;

 

*/