One way to address the issue would be to use a tool to create a 'ticket' based off of the alert email that is already being sent from the task failing. I will continue digging into possible solutions for this scenario.
Good Question vinod.
Currently the only way is to look into the extracts jobs on the server admin views .
2.) I believe we can try to work it out of the postgres repository ,I haven't checked it but will try to do the research from my end.
Thanks for your reply. I did some research on this and there is something called Connect IT in HPSM for auto creating tickets from emails. But I am not sure how does that work, If it works, I am not sure if my organization adopts that Connect IT.
I have few questions came into my mind when exploring options. If we custom query postgres or if we download failures from custom admin report, both cases it gets downloaded as bulk (ie; more than a single record). In this case How can we create a ticket for each single failures, if we download\get them as a list.
I got struck with those questions. If they just need an email alert, we can do that with not much complications.
We use HPSM for Incidents.
Any help is greatly Appreciated!
Thanks for your reply. Yes, we can get the status from Postgres. In all cases we can get the failure details as a list (else we need to query each schedule or workbook for each failure, which is not a good option). After getting the list of failures, I am not sure how to auto create ticket for each failure.
Any help from your side is greatly appreciated!