Export, Import : Oracle

create or replace view svjobs as
select
      T.*,
        J.JOB JobId,
        case
                when nvl(J.Failures,0)=0 and nvl(J.Broken,'N')='N'
                      and (T.TimeLimitExceeded='0')
                     then '0'
  else '1'
  end IsBroken,
       Schedule.Unix2DOS(J.WHAT) What,
     J.LAST_DATE LastDate,
       J.NEXT_DATE NextDate,
       nvl2(J.THIS_DATE,'1','0') IsRunningNow,
 J.THIS_DATE RunSince,
       J.Interval SysInterval,
     decode(nvl(lower(J.Interval),'null'),'null','0','1')
                ScheduleEnabled
     from SVSysJobs J, SMControlTasks T
  where J.OurTaskID(+)=T.ID