https://userapps.support.sap.com/sap/support/knowledge/en/3170570
3170570 - How to set a threshold for Report Schedule about to Expire | SAP Knowledge Base Article
I am using report schedule with delivery type attachment I want a notification when the report schedule is about to expire