SET QUOTED_IDENTIFIER OFF
GO

CREATE VIEW ujo_jobrow AS
SELECT  j.joid, j.job_name,j.job_type,j.owner,j.permission,
        j.box_joid,j.machine,j.n_retrys,
        j.date_conditions,j.days_of_week,j.run_calendar,j.exclude_calendar,
        j.start_times,j.start_mins,j.run_window,
        j.command,
        j.description, j.term_run_time,
        j.box_terminator,
        j.job_terminator,j.std_in_file,j.std_out_file,j.std_err_file,
        j.watch_file,j.watch_file_min_size,j.watch_interval,
        j.min_run_alarm, j.max_run_alarm, j.alarm_if_fail,
        j.chk_files,j.free_procs,j.profile,j.heartbeat_interval,
        j.auto_hold,
        j.job_load,j.priority, j.auto_delete, j.numero,
        j.max_exit_success, j.box_success, j.box_failure,
        status,status_time,last_start,last_end,next_start,run_window_end,
        exit_code,run_machine,que_name,jc_pid,pid,
        run_num, ntry, appl_ntry, last_heartbeat,
        run_priority, next_priority, evt_num, over_num,
        b.job_name box_name,j2.command2, j2.external_app, j2.timezone,
        j2.as_applic,j2.as_group,j.send_notification, j.service_desk
FROM  ujo_job_status s , ujo_job2 j2, ujo_job j
LEFT OUTER JOIN ujo_job b ON j.box_joid = b.joid
WHERE j.joid = j2.joid AND s.joid = j.joid

GO
GRANT SELECT ON  [dbo].[ujo_jobrow] TO [ujoadmin]
GO