Need to send an email notification on weekly basis to remind project complete date to PM?

[Deepika61]

Hi All,

Actually i have requirement that  need an email notification to be sent to me on project complete  date to the project manager on weekly basis untill all stories marks as complete

And Email notification to include link to agile board 

I have idea that create a schedule job in that

1. need to check that project end date 

2. if end date not completed then need to check if stories are complete or not

3. if stories are still not complete then we need to trigger an event

These are the steps to follow, so i need schedule script to achieve this?

Please help me to achieve this 

Thanks

Deepika

[Mark Roethof]

"but its miss something"

Can you be a bit more specific? What do you think you are missing? Or is the code not working at all?

[Deepika61]

@Mark Roethof 

Actually it means that its not working , what needs to add to trigger notification ?

Can you please review and make the corresponding changes on my script?

Thanks

Deepika

[Deepika61]

Hi Everyone,

Please help me to complete this 

the schedule job which i did was not working

var projectEnd = new GlideRecord('customer_project');
projectEnd.addEncodedQuery('active=true^u_project_template=false^state!=3^approved_end_date>=javascript:gs.beginningOfToday()');
projectEnd.query();
while (projectEnd.next()) {
var story = new GlideRecord('rm_story');
story.addEncodedQuery('project', story.project.toString());
story.addQuery('state!=3');
story.query();
while (story.next()) {
gs.eventQueue('sn_csm_ppm.cg_project_end', story, story.project.project_manager, '');
}
}

Thanks 

Deepika

[Mark Roethof]

So is the script not working? Or is the scheduled job not triggered at all? Did you test the code in for example a background script, did it work?

Please do be more specific so people can really help you.

[Deepika61]

@Mark Roethof 

My script is not working , so the event was not triggering, if possible you can provide the script based on my requirement?

i have already mentioned my requirement clearly , i have tried my self , whether its right or wrong  not sure, so i have posted here to review by someone and made the changes to my script or

except new script if my code was not correct

Thanks

Deepika