DECLARE
  job BINARY_INTEGER := :job;
  next_date TIMESTAMP
WITH TIME ZONE := :mydate;

broken      BOOLEAN      := FALSE;
job_name    VARCHAR2(30) := :job_name;
job_subname VARCHAR2(30) := :job_subname;
job_owner   VARCHAR2(30) := :job_owner;
job_start TIMESTAMP
WITH TIME ZONE := :job_start;

window_start TIMESTAMP
WITH TIME ZONE := :window_start;

window_end TIMESTAMP
WITH TIME ZONE := :window_end;
BEGIN
  BEGIN
    EXECUTE IMMEDIATE('alter index pagecontents_index rebuild online parameters(''sync'')');
    COMMIT;
  END;
  :mydate := next_date;
  IF broken THEN
    :b := 1;
  ELSE
    :b := 0;
  END IF;
END;