Oracle dbms_job：作业只能在工作日的上午6点至晚上8点运行

   ,next_date => to_date(\'27.04.2011 10:18:00\',\'dd/mm/yyyy hh24:mi:ss\')
   ,interval  => \'to_date(to_char(sysdate + (2/24), \'\'DD.MM.YYYY HH24:MI\'\'), \'\'DD.MM.YYYY HH24:MI\'\')\'

case
  when to_char(trunc(sysdate, \'HH24\') + 2/24, \'HH24\') between \'06\' and \'20\' then
    trunc(sysdate, \'HH24\') + 2/24 
  else
    trunc(sysdate)+1+(6/24)
end

case
  when
    to_number(to_char(sysdate, \'D\')) between 1 and 5 then
      case
        when to_char(trunc(sysdate, \'HH24\') + 2/24, \'HH24\') between \'06\' and \'20\'
                                                                            then 
          trunc(sysdate, \'HH24\') + 2/24 
        else 
          trunc(sysdate)+1+(6/24)
        end
  else
    trunc(sysdate) + (8 - to_number(to_char(sysdate, \'D\'))) + 6/24
end