Send Notification 24 Hours Prior To Planned Start Date

tiguin2798
Tera Guru

Everyone,

I am trying to have a notification fire on an event when a change is 24 hours prior to the planned start date if it contains a critical system. I have created the event and scheduled job, but it does not appear to be firing. This is my first time creating a scheduled job so I am unsure if that (or my code) may be configured incorrectly.

Also in this case, would the 24 hour prior to the "Planned Start Date" portion even need to be included in my notification conditions? Or would this be something that is scripted into my scheduled job?

tiguin2798_0-1716577437749.pngtiguin2798_1-1716577443265.pngtiguin2798_2-1716577444848.png

 

11 REPLIES 11

tiguin2798
Tera Guru

I have since removed the business rule and now only have the notification sending once the event is fired from the scheduled job. However, this still does not appear to be working. I believe my script is correct below if someone could please confirm?

Although, I am also curious if I need to add a trigger to the scheduled job of when it would run or if this is being fired off from the script in the scheduled job? Rather, what is causing the scheduled job to run the script....or do the calendar dates suffice? Basically I want the system to constantly be checking if a change is 24 hours ahead of the planned start time if it contains a critical system.

 

tiguin2798_0-1717511329890.pngtiguin2798_1-1717511334516.png

 

tiguin2798
Tera Guru

Everyone, I have been able to successfully achieve getting my event to trigger from a business rule and send out the notification as expected. However, I am still having some issues with the time frame I need this to send out. I can do the planned start date is relative to 24 hours before/after now, but cannot seem to do an 'and' condition on the planned start date as doing so never triggers the event. My goal is to send this notification only when the planned start date is 24 hours from now, but not when that 24+ time is a week from now for example.

So if someone has a change that say goes in to scheduled on 6/26 but the planned start date is for 6/30...I would want the notification to send on 6/29. Any ideas on how this portion can be achieved? I even tried doing this for planned on tomorrow, although it seems like then it only does it if it goes in to scheduled for example on 6/26 and the planned start date is for 6/27 but not if the planned start date was for 6/28 or further.

tiguin2798_0-1719327087204.png

tiguin2798_1-1719327153280.png