/****** Object:  Stored Procedure dbo.ujo_sum_rep    Script Date: 12/1/2005 11:49:51 PM ******/

create proc  ujo_sum_rep
    @joid int

AS

SELECT     job_name,job_type,status,last_start,last_end,
    run_num,ntry,exit_code,run_priority
FROM     ujo_jobst
WHERE     joid=@joid

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