For new indicators, historic job collections are run for 12 times to collect each month for the last year.
We are only cutting up the 12-month job to avoid any potential time outs.
This is done manually, although I want to ask if anyone has developed a script to automate this?
Possibly using Script Include?
The reason for automation is to reduce the need for a person to monitor each job is complete before running the next month.
This process may need to be done in several environments, so automation will hopefully help to reduce the time these jobs would take to run manually and improve accuracy by removing potential human error when selecting the period to collect.
Requirements:
1. Use the Job(s) Specified in the script.
2. Run first month (most recent start of month - date update set was deployed and begun to collect daily metrics).
3. Once the first month is complete, run the next month.
4. Repeat step 3 until all jobs are collected.
5. If any jobs have an 'error', stop the process send an email to person/team defined in the script.
May need to set as 'fixed dates', incase the collection crosses multiple days.
This would mean there is potential of missing a day if automating relative days.
Thanks for your help
