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


create proc ujo_job_lookup
    @job_name    varchar(65),
    @job_type    char(1),
    @box_name    varchar(65)

AS
if @job_name != '%'
    select @job_name=@job_name + '%'

select    j.joid,
    substring( j.job_name + '                             '  , 1, 65 ),
    j.job_type,
    substring( b.job_name + '                             ', 1, 65 )
FROM ujo_job j right join ujo_job b on b.joid = j.box_joid
where    j.job_name like @job_name

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