I have a project that runs a sequence job (SQ1) on a nightly basis. The SQ1 job does various tasks like check connection, runs staging jobs, facts, dimensions etc. The staging job (SJ1) is a server job that executes a text file containing various sequence and server jobs.
I would like to run the scheduled sequence job (SQ1) and be notified by email when there is an error in one of the jobs being run. The problem is that if I but a notification activity on the SQ1 job with a trigger of failed I get no email when one of the lower jobs fails because the staus of the SJ1 staging job is not aborted, the staus is "Finished (see log)". The jobs in the text file being run in by SJ1 are not dependant so I would like the rest of the jobs to run even if one of them fails, but I would like to receive a notification from the failing job. There are many, many jobs and I don't want to add notification to each and everyone. Is there a way to have a setting at more of a global level to inform me of any failing jobs?
receiving notification when a job fails
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
Welcome Aboard! :D
Have the "Notification_Activity" attached to SQ1 removed.
In the main job sequence, add an independent section, with an "Exception Handler" stage followed by a "Notification_Activity".
Make sure you have the "Automatically handle activities that fail" checked in the "Job Properties" of the job sequence.
HTH,
Whale.
Have the "Notification_Activity" attached to SQ1 removed.
In the main job sequence, add an independent section, with an "Exception Handler" stage followed by a "Notification_Activity".
Make sure you have the "Automatically handle activities that fail" checked in the "Job Properties" of the job sequence.
HTH,
Whale.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Get the jobs out of the text file and into a job sequence where you can directly connect triggers to Notification and other activities.
Otherwise put a lot more work into your text file (shell script) to detect the exit status of jobs and log/notify those results.
Or create a job or routine to scan the statuses of those jobs so as to report/log/notify their results.
Otherwise put a lot more work into your text file (shell script) to detect the exit status of jobs and log/notify those results.
Or create a job or routine to scan the statuses of those jobs so as to report/log/notify their results.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Change your screen resolution or get your eyes checked. It's OK for me (at 1024 x 768), and I'm (probably) older than thee.
Observation: The OP marked the job type as parallel.
Observation: The OP marked the job type as parallel.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
I have the same screen resolution, and my eyes are 6/6. It was just an innocent comment
I can read it but its, small.
I can read it but its, small.
Last edited by DSguru2B on Mon Jan 29, 2007 3:15 pm, edited 1 time in total.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
I observed that as well and didn't feel it was relevant. Is not the General forum where (amongst other things) Sequence job questions are 'supposed' to go? Maybe we need a 'Sequence' job type choice...
Roy, feel free to snip all the chit chat when you move this - where ever it ends up.
Roy, feel free to snip all the chit chat when you move this - where ever it ends up.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers