huawei--创建job，判断是否已经存在

CREATE OR REPLACE PROCEDURE spQcJob
AS
  v_jobname NUMBER;
  v_date DATE;
  v_Count int;
BEGIN

  select count(*) into v_Count from dba_jobs where what='spOprScoreDaily;';
  IF v_Count>0 THEN
  select job into v_jobname from dba_jobs where what='spOprScoreDaily;';
  sys.DBMS_JOB.REMOVE(v_jobname);
  END IF;
  v_date := TRUNC(SYSDATE+1,'DD')+6/24;
  sys.DBMS_JOB.SUBMIT(v_jobname,'spOprScoreDaily;',v_date,'TRUNC(SYSDATE+1,''DD'')+6/24');
  COMMIT;
END spQcJob;
/
EXECUTE spQcJob;
/
DECLARE
  v_Job NUMBER;
BEGIN
  DBMS_JOB.SUBMIT(v_Job, 'p_maintendata;', TRUNC(SYSDATE), 'SYSDATE + 1');
  COMMIT;
END;
/