CREATE TRIGGER [Astea_Insert] ON dbo.TrackData 
AFTER INSERT 
AS
 
/* Call Stored Procedure in AsteaSQL Server */


DECLARE @Astea_Serial varchar(30)
DECLARE @Astea_Error_Code varchar(8)
DECLARE @Astea_Text varchar(254)
DECLARE @Astea_DT datetime
DECLARE @Astea_ErrorLevel int
DECLARE @Result int
DECLARE @ErrorVal int

SELECT @Astea_Serial = i.SerialNumber FROM Inserted i
SELECT @Astea_Error_Code =i.ErrorCode FROM Inserted i
SELECT @Astea_Text = i.Text FROM Inserted i
SELECT @Astea_DT = i.Time_Stamp FROM Inserted i
SELECT @Astea_ErrorLevel = i.ErrorLevel FROM Inserted i

IF @Astea_ErrorLevel < 3 OR @Astea_Serial = 'REMTEST'
	RETURN

EXECUTE [Server2].Enov_Dev.dbo.fj_create_monitor @Astea_Serial,@Astea_Error_Code,@Astea_Text,@Astea_DT,@Result OUTPUT

Select @ErrorVal = @@ERROR

/* Record Error for Diagnostics */
IF (@ErrorVal != 0 OR @Result != 0)
	BEGIN
	INSERT INTO SysError (IDKey,IDKey2,RetVal,Msg) 
		Select i.TrackDataIDKey,i.DB2_Key,@ErrorVal,'ASTEAINS' 
		FROM inserted i
	END

CREATE PROCEDURE fj_create_monitor
 @serial_no varchar(30),			 /* Serial Number  */
@error_code varchar(8),		 /* Error Code  */
@comment  varchar(254),		 /* Comment  */
@created_at  datetime,		/* timestamp  */
@l_return integer output
 as
 

  INSERT INTO fj_monitor  
         ( comment,   
           created_at,   
           error_code, 
           serial_no )  
  VALUES ( @comment,   
           @created_at,   
           @error_code,
	  @serial_no)  	
	IF @@error <> 0
 	BEGIN
 		select -1
 		return 
 	END
 
	--Commit
	select 0
	return
GO