Question
TCS
US
Last activity: 30 Mar 2023 2:11 EDT
Job Scheduler - Send Email
Hi
We have a requirement in our project to send email once the Job scheduler is started & completed with the status. Can any one help me how to determine if Job scheduler is completed? I did some analysis and found Job details are stored in class Log-Jobscheduler. I thought of creating a declare trigger on this class and generate the emails based on starttime, endtime and jobname. But declare trigger (on SAVE) is not getting triggered after the completion of Job scheduler. Is my approach correct or do we have any other way to achieve this?
Thanks in advance
Bits in Glass
IN
@John Joseph BIX extract captures the history with start time and end time along with duration when it is processed by job shceduler. Can you check how that is happening and you can replicate the same for your scenario.
Coforge
IN
You can have sendemail logic called in the last step of your scheduler activity with required details. So as soon as your job is getting ended, email will get triggered.
And if you want to get the details of all the jobs at once in single email. create a data type which will get updated at the last step of your jobs activity. If you do not need historical run details, you can have JobNames as the primary key and keep on updating the respective record for each job run. Now you can use schedule report (this RD will fetch the details from the data type) feature to get the details through email of all the jobs at once.
Bits in Glass
IN
@John Joseph I have checked the bix history, the data is being pulled from Log-Extract. So your approach of using Log-Jobscheduler is right, it has all the details like start time, end time, job schedulername and others. But not sure why declare trigger is not working in your case. If not working, You can try to use job scheduler if its fine for your requirement, to send execution list by pulling the list using RD from Log-Jobscheduler and sending it over email every week or something similar.
TCS
US
@Anoop KrishnaThanks. Declare Trigger is working fine when i try to update an instance in Log-Jobscheduler through an activity but this is not getting triggered when Pega updates it after the completion of Job-Scheduler. Planning to create a new Job scheduler which will look into Log-Jobscheduler for the Job completion and send email accordingly.
Coforge Limited
IN
I hope you have used Obj Save method when you are tried to save an instance using Activity. Can you verify Is Pega using obj-methods to save/create an instance of Log-JobScheduler when a job scheduler gets completed?