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

create proc ujo_put_monbro
    @name        varchar(30),
    @mon_mode    char(1),
    @do_output    char(1),
    @sound        tinyint,
    @alarm_verif    tinyint,
    @alarm        tinyint,
    @all_events    tinyint,
    @all_status    tinyint,
    @running    tinyint,
    @success    tinyint,
    @failure    tinyint,
    @terminate    tinyint,
    @starting    tinyint,
    @restart    tinyint,
    @on_ice        tinyint,
    @on_hold    tinyint,
    @job_filter    char(1),
    @job_name    varchar(64),
    @currun        tinyint,
    @after_time    varchar(20),
    @autoserv    varchar(30)

AS


if not exists ( select * from ujo_monbro where name = @name )
begin
    insert ujo_monbro (
    name        ,
    mon_mode        ,
    do_output        ,
    sound        ,
    alarm_verif    ,
    alarm        ,
    all_events        ,
    all_status    ,
    running        ,
    success        ,
    failure        ,
    terminate    ,
    starting    ,
    restart        ,
    on_ice        ,
    on_hold        ,
    job_filter    ,
    job_name    ,
    currun        ,
    after_time    ,
    autoserv
    )
    values (
    @name        ,
    @mon_mode    ,
    @do_output        ,
    @sound    ,
    @alarm_verif    ,
    @alarm        ,
    @all_events        ,
    @all_status    ,
    @running    ,
    @success    ,
    @failure    ,
    @terminate    ,
    @starting    ,
    @restart    ,
    @on_ice        ,
    @on_hold    ,
    @job_filter    ,
    @job_name        ,
    @currun        ,
    @after_time    ,
    @autoserv
    )

        
    return 1
    
end

/* Must be an update  */


update    ujo_monbro
set    
    name        =    @name,
    mon_mode    =    @mon_mode,
    do_output    =    @do_output,
    sound        =    @sound,
    alarm_verif    =    @alarm_verif,
    alarm        =    @alarm    ,
    all_events    =    @all_events    ,
    all_status    =    @all_status,
    running        =    @running,
    success        =    @success    ,
    failure        =    @failure    ,
    terminate    =    @terminate,
    starting    =    @starting,
    restart        =    @restart,
    on_ice        =    @on_ice    ,
    on_hold        =    @on_hold,
    job_filter    =    @job_filter,
    job_name    =    @job_name    ,
    currun        =    @currun    ,
    after_time    =    @after_time,
    autoserv    =    @autoserv

where    name = @name

if @@rowcount = 1
    return 1

return -1
GO
GRANT EXECUTE ON  [dbo].[ujo_put_monbro] TO [ujoadmin]
GO