Need to migrate a customer from version 8.0 to 11.x
I want to get a list of all the projects, jobs they have defined
which are in the thousands.
I would like to get a list of the jobs per project and the date time the
were last run, so that I could put them in a spreadsheet and review with
customer to see if these jobs are really required and eliminate the ones
that they are not running and save me migrating them.
Is there any way I can generate the list in a simple column format for loading into a spreadsheet?
DSODB was only introduced in 8.7 if I recall correctly, so not there in 8.0
Are there other tables in XMETA that I could extract this information from?
Looking to get
- Project
- Job name
- status
- Started
- on date
- last ran
- on date
- elapsed time
- description
I can only think of doing a shell script something like
Code: Select all
for PROJECT in $(/u01/IBM/InformationServer/Server/DSEngine/bin/dsjobs -lprojects)
do
for JOB in $(/u01/IBM/InformationServer/Server/DSEngine/bin/dsjobs -ljobs ${PROJECT} )
do
# /u01/IBM/InformationServer/Server/DSEngine/bin/dsjobs -logdetail ${PROJECT} ${JOB}
/u01/IBM/InformationServer/Server/DSEngine/bin/dsjobs -jobinfo ${PROJECT} ${JOB} > ${PROJECT}_${JOB}.jobinfo
cat ${PROJECT}_${JOB}.jobinfo >> ${PROJECT}_AllJobs.jobinfo
done
done
Is there a better to do this?
Thanks