Hey All,
Just to add another option on the table that is a little different. Someone may remember this from way back. It may have been version 3 or 4 I first created this for.
Attached is a spreadsheet (GetJobInfo.xlsm) with a small macro inside. It contains instructions on how to run the macro on one tab, and an example of the output on the next tab. The steps are below.
In dSeries:
Download the schedule, then do a right click and "Save As". Save it to C:\Temp\
In Excel:
1) Open the spreadsheet.
2) If a yellow warning message pops up select the "Enable Content" to enable the macro.
3) Run the macro by going to the "View" tab on the top toolbar, Click the Macros icon, highlight "GetJobData" and click "Run"
4) When prompted for the schedule name put in the schedule name. Do not include the .xml extension
Advantages:
I think it is easier to read
It puts all the information for the same job on a single line. A cell may show that the job has 10 run criterias or that it releases 5 jobs.
The Excel file doesn't contain every scrap of information that the XML file has.
Disadvantages:
The Excel file doesn't contain every scrap of information that the XML file has.
Let me know what anyone thinks. I will keep it to myself if no one sees any value in it.
Fields can be added if needed/requested. Send me an example .xml file for any fields that are needed.
2¢
Don