Stored Procedures [dbo].[send_event]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@eoidvarchar(12)12
@joidint4
@job_namevarchar(64)64
@box_namevarchar(64)64
@AUTOSERVvarchar(30)30
@priorityint4
@eventint4
@statusint4
@alarmint4
@event_time_gmtint4
@exit_codeint4
@machinevarchar(80)80
@pidint4
@jc_pidint4
@run_numint4
@ntryint4
@textvarchar(255)255
@que_priorityint4
SQL Script
/****** Object:  Stored Procedure dbo.send_event    Script Date: 12/1/2005 11:50:12 PM ******/

create proc send_event
    @eoid       varchar(12),
    @joid       int,
    @job_name   varchar(64),
    @box_name   varchar(64),
    @AUTOSERV   varchar(30),
    @priority   int,
    @event      int,
    @status     int,
    @alarm      int,
    @event_time_gmt int,
    @exit_code  int,
    @machine    varchar(80),
    @pid        int,
    @jc_pid     int,
    @run_num    int,
    @ntry       int,
    @text       varchar(255),
    @que_priority   int    

AS
begin

exec ujo_send_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

end
return 1
GO
Uses