Hi @Vinay52 ,
You need to write a schedule job, to keep checking the pre 24 hours and post 48 hour duration and trigger the email notification for all CHG fall under the condition. The schedule job script will glide over change_request table and compare the Planned End Date with current date, the hour different should be within 24 to 48 hour for pre notification.
-Thanks,
AshishKM
Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution
