sp_After_Email_Job

sp_After_Email_Job is triggered upon completion of an e-mail job.

Remarks

This procedure should not be called directly by developer, it is automatically called by Boomerang services after completion of a job. This handler is invoked by Boomerang services both in event of success and failure.

Default body of this procedure is blank, thus user may provide their own code implementation for follow-up purposes.

[important]Any changes to handler parameter list cannot be made. New parameters may add with future Boomerang releases upon which a notice will be sent separately.[/important]

Syntax

exec sp_After_Email_Job @jKey=..., @lKey=... , @error_level=...

Parameters

Column Name	Data type	Direction	Description	Default	Status
@jKey	uniqueidentifier	in	Job key jKey found in OUT_EMAIL table		Required
@lKey	uniqueidentifier	in	Log entry key lKey found in EVENT_LOG table		Required
@error_level	int	in	Error status (0 = success, 1 = business, 2 = system)		Required

Return Code Values

0 (success) or non-zero (failure)

Examples

Tag customer order shipment confirmation as “sent”.

-------Sample--------
/*******************************************************************
  08-11-14 [DPA] - new object; User event
  09-03-31 [DPA] - process shipment confirmations, PD# 18478
*******************************************************************/
ALTER procedure dbo.sp_After_Email_Job
(
  @jKey uniqueidentifier ,
  @lKey uniqueidentifier ,
  @error_level int 
)
as begin
  set nocount on
  declare @src int, @int1 int
  declare @ordNo varchar(100), @Cust varchar(100)
 
  if( @error_level!=0 ) return		/* do nothing on errors */
 
  select top 1				/* get job details */
    @src 	= Source,
    @ordNo	= Str1,
    @Cust	= Str2,
    @int1	= Int1
  from OUT_EMAIL j with(nolock)
         inner join 
       EVENT_MASTER g with(nolock) on g.gKey=j.gKey
  where jKey=@jKey
 
  if( @src=40 and @int1=10 ) begin	/* was this a shipment confirmation job? */
    if( @ordNo like '_002%' )
      exec erpDB.dbo.sp_update_shp_flags @ordNo, @Cust, 'Type-A', ''
    else
      exec erpDB.dbo.sp_update_shp_flags @ordNo, @Cust, 'Type-B', ''
  end
 
end