Applies To
	Product(s):	eB Work Orders
	Version(s):	15.04.01, 16.x.x
	Environment:	N/A
	Area:	eB Work Orders
	Subarea:	N/A
	Original Author:	Swapnil Tapadia, Bentley Technical Support Group

 

 

 

 

 

 

 

Scenario
========

User wants to send an e-mail notification for late work task.

Solution

=======

In order for late work task email’ setting to be used, as part of eB Workflow/email notification configuration, it needs a scheduled job for it to work.
The scheduled job needs the stored procedure "ebp_resolve_notifications" to be called by either a sqlserver agent job or in Oracle by scheduling a job in Oracle.
Below is the standard way to execute the procedure in SQL Server:

begin tran
execute ebp_resolve_notifications @pi_type=1, @pi_called_by=1;
commit;
go

Here @pi_type is notification type to be performed and @pi_called_by is session id (i.e. person id)
 
Set the notification type parameter to 1,2 or 3 as follows notify if:
 1 = planned start date reached and task is still in inbox
 2 = planned end date has passed and task is not completed
 3 = perform both types of notifications.