send email to respective project owner a month before as reminder to renew the Project end date

[Somasekhar6]

HI team I have one table which consists of Project details along with dates and manger details as below

Project Code	Project Name	Project Manager	Allocation start date	Allocation End Date
1001	IT_SAP	Soma Sekhar	01-25-2024	07-31-2024
1002	IT_JAVA	Jaya	01-25-2024	07-31-2024

Need to send email to respective project owner a month before as reminder to renew the Project Allocation . How Could we achieve this Could you please help on this ?

I know we can achieve with help of schedule job could you please help me with script ?

Thanks for your Time and support.

[Mio Matsushita]

Hello.

As you may have guessed, you can achieve this requirement using a scheduled job.

The following is to be created
1. Event
2. Notification
3. Scheduled Job

1. Event
First, create an event to be fired when a condition that requires notification is met.
The event is tentatively named “project_reallocation_reminder”.

2. Notification
Next, create a notification for the Project table.
In the [When to send] tab, set [Send when] to [Event is Fired] and specify the event created in step 1 in the [Event name] field.
Do not forget to set [Event parm 1 contains recipient] in [Who will receive] to True.

3. Scheduled Job
Finally, create a scheduled job.
A scheduled job is set to run periodically at any given time.
The script should trigger the event created in step 1 when a condition is met.
The condition is, for example, one month before the allocation start date.
When triggering the event, include the project owner as the recipient of the notification.

gs.eventQueue('project_reallocation_reminder',current,project_owners);

If you try this procedure and it does not work, please let me know.