/****** Object:  Stored Procedure dbo.ujo_init_jobset    Script Date: 12/1/2005 11:49:50 PM ******/
create proc ujo_init_jobset
as
select
    j.joid,
    j.job_name,
    j.job_type,
    j.box_joid,  
    b.job_name,    /* box_name */
    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.term_run_time,
    j.box_terminator,
    j.job_terminator,
    j.min_run_alarm,
    j.max_run_alarm,
    j.alarm_if_fail,
    j.auto_hold,
    j.job_load,
    j.priority,
    j.auto_delete,
    j.max_exit_success,
    j.box_success,
    j.box_failure,
    avg_runtime
from ujo_job j left join ujo_avg_job_runs on j.joid = ujo_avg_job_runs.joid,ujo_job j2 left join ujo_job b on j2.box_joid = b.joid

return -999 /*SUCCESS*/
GO
GRANT EXECUTE ON  [dbo].[ujo_init_jobset] TO [ujoadmin]
GO