Email Notification for Pending Project Tasks to respective Managers

MadanK
Kilo Contributor

Need help in sending email with all pending Project tasks to the teams Manager / Sr. Management on a daily / weekly / monthly basis. So that we have Management's intervention for better our Task SLA's.

2 REPLIES 2

Saba Baig
Tera Contributor

 

For which table do you want?
Suppose if all pending task are in [sc_task] table then 

1.Create event and  email notification which triggers on when event is fired.

2.Create schedule job which triggers that event 

3.In schedule Job write script on basis of created date

Jitendra Diwak1
Kilo Sage

Hi @MadanK,

 

this can be achieved by flow designer. You can set the if condition and check the pending task then apply the Wait for condition and set the duration then fire the event to send the notification.

 

Please accept my solution if it works for you and thumps up.

 

Thanks

Jitendra

Please accept my solution if it works for and thumps up.