create proc ujo_move_event
    @eoid        varchar(12),
    @que_status  int
AS

declare @error_var     int,
        @rowcount_var  int
        
    if( @eoid is null )
    begin
        raiserror ('Input parameter eoid cannot be null', 16, 1)
        return -1
       end
       else if( @que_status is null )
    begin
        raiserror ('Input parameter que_status cannot be null', 16, 1)
        return -1
       end
       
       select @error_var = 0
    select @rowcount_var = 0
    
    update    ujo_event
    set    que_status = @que_status
        where eoid = @eoid

    SELECT @error_var = @@error, @rowcount_var = @@rowcount        
    
    if (@error_var != 0 )    
    begin
        raiserror ('procedure ujo_move_event failed during update with error:%d', 16, 1, @error_var)        
        return -1
    end    
    
    if (@rowcount_var !=1)
    begin        
        raiserror ('Invalid Event(%s)', 16, 1, @eoid)        
        return 0
    end
    
       
       select @error_var = 0
    select @rowcount_var = 0
    
    insert into ujo_proc_event (eoid, joid, job_name, box_name, AUTOSERV, priority,
                                event, status, alarm, event_time_gmt, exit_code, machine,
                                pid, jc_pid, run_num, ntry, text, que_priority, stamp,
                                evt_num, que_status, que_status_stamp)
    select *
    from ujo_event
    where eoid = @eoid
    
    SELECT @error_var = @@error, @rowcount_var = @@rowcount        
    
    if (@error_var != 0 )    
    begin
        raiserror ('procedure ujo_move_event failed inserting event into ujo_proc_event with error:%d', 16, 1, @error_var)
        return -1
    end    
    
    if (@rowcount_var = 1)
    begin
        delete from ujo_event where eoid = @eoid
    end
    
return 1
GO
GRANT EXECUTE ON  [dbo].[ujo_move_event] TO [ujoadmin]
GO