AnsweredAssumed Answered

Email notifications for failed schedules

Question asked by jdafoe on Jul 29, 2013
Latest reply on Aug 27, 2013 by jdafoe

We're required to create a daily alert/email notification containing all schedules that failed on a given day so that they can be later further investigated for the cause of failure. Since PAM doesn't offer generic support for this task (i.e. email alerts for failed schedules), I think we would be required to create a custom solution that queries the ITPAM database for all failed schedules for the day and then email them.

I tried to look directly at the SQL tables to figure out how I would get this info but can't figure it out. Has anyone done something similar? Or is anyone able to point me in the right direction?

Basically the query would be:

Select all process that were started by a Schedule Object,
where status=failed and date=today.

I have attached a screenshot of exactly what kind of info/report I'm trying to generate.