I would like to create a report of all failed jobs and import it into an Excel spreadsheet. Is there any way of generating a list of only failed jobs?
add new comment
(comments are locked)
|
This can be done by creating a perl script using findObjects. If you run the command NOTE: These scripts must be converted from .txt to .pl due to .pl files being unsupported on ask. I have attached a script jobs.txt that only outputs the jobs with 'outcome' equals 'error'. You can run this script with the command The output of this script will be in xml format. If you want to import this data into Excel, you must format the data as csv. I have attached a script format.txt that takes in a file 'jobs.xml' and outputs every job's ID, name, and finish date, separated by a semicolon and on a new line for each entry. The output is stored in 'report.csv'. You can execute the script by running You can use these scripts as a template to modify further to fit your needs.
(comments are locked)
|
Topics:
asked: Mar 06 at 06:16 PM
Seen: 31 times
Last Updated: Mar 13 at 11:40 PM