'Book templates expiring within the next 2 months' is the notification sent everyday at 6:00 AM to the email group ‘A_Product <[email protected]>’

 

It checks which enabled itinerary templates in Travel Centre are expiring within 2 months from present day. 

 

 

 

For Dev:

 

  • This is  set up as a job in PRDSQL4 -> Job Name : SD-Booking Template Expiry Email
  • Stored Proc on SD_travel , executed here is : usp_Book_SendBookTemplateExpiryEmail