Import Procedure that contains 1000+ line of codes
import from Oracle SQL server and move to MS SQL server using a special connector, hence the red lettering
-
Convert source data to destination data format (data wrangling)
-
Delete last 2 month of transactions and replenish with latest 2 month data
-
Check for duplicates and delete duplicates
-
Rollback (cancel procedure) if there is any errors
![](https://www.jiangyanqing.com/wp-content/uploads/2021/12/Expiration-Notification.gif)
Import Procedure that send bi-weekly emails on Contract Expiration
MS SQL Server import procedure with Outlook connector
-
Extract last 2 month and future 2 month expired contracts from NA, SA, APAC regional servers
-
Extract a list of procurement team members from Azure active directory (employee list)
-
Send email with HTML formated table
-
Auto execute this procedure with Zena on a bi-weekly basis
Email with HTML Table sample
![](https://www.jiangyanqing.com/wp-content/uploads/2021/12/Email.png)