You can create a script to save relevant job settings in MS Access or other database.
You can use JobList command to get the list of all scheduled jobs and then you can loop through that list. JobDescribe command can be sed to describe job properties. DatabaseConnect, DatabaseInsert, DatabaseUpdate and DatabaseExecute can be used to export data into a relational database. For the list of available job properties see JDL Properties topic in the on-line help. For an example of using JobList see JobList topic and then hit the Examples button. PS. Last job run is not availabe as a property you woulld need to parse the log file to find it. See schedule.log file for details. : I would like to be able to create my own report.
: Similar to the Job Summary Databse report but adding
: fields like host, actual time instead of Daily,
: Last run, Description, etc... : We are in the process of upgrading from office 97 to
: office 2002 and with 3 machines running jobs it would
: be nice to be able to tell quickly what is running where
: i have been missing jobs in the switch and they fire up on the 97 pc
: instead of the 2002 pc : Is there away to link an Access db or something
: to this information to extract it? : Just checking : Thanks
|
