on 09-03-2015 3:15 PM
hi all,
we have a requirement to alert our BODS team for these 2 scenarios,
please suggest an approach to automate this:
scenarios:
1. in case any bods job execution takes more than its threshold time , then an email has to be sent to a team.
the threshold time can be calculated like this for each job : average time taken in the last 15 days [or any other better calculation]
2. in case any bods job dint get triggered on any day, then an email has to be sent to a team.
(1) you can capture the starting time in a script with a variable, then execute a script after your data/workflows complete. Do a time comparison and use the email function smtp_to and send the email.
You could use this value in a statistics table in your target system and do some basic SQL to insert new values and do calculations based on this.
For (2), you would then be able to check if the job ran the previous day. I'm not sure a good way to notify if the job doesn't run (especially for example if your system was down) but perhaps you could have a job on the target running a stored procedure every day to verify a new entry exists in your statistics table.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.