Synopsis
jobschprintcsv -g MM DD YYYY [-title] [-vparam] [-sys subsystem-number](*1)
[-sys subsystem-number] is the option of Systemwalker Operation Manager EE.
Description
The jobschprintcsv -g command outputs the execution result history of job nets to standard output in CSV format.
Saving the output result in a file enables the execution result history to be managed with spreadsheet software. (Note)
Before importing the output result into the spreadsheet software, it is necessary to convert it into the character code supported by that spreadsheet software.
Options
-g
Outputs the history information on the job net that can be browsed by the user executing this command.
MM
Specify the month in which the date you want to output appears, in one or two digits.
DD
Specify the date that you want to output, in one or two digits.
YYYY
Specify the year in four digits.
-title
If this option is specified, the title is output on the first line.
-vparam
Displays the variable parameters for job nets that were started by specifying a variable parameter.
-sys subsystem-number
In the system with multiple subsystems, this option is used to specify the subsystem that you want to operate. Specify the target subsystem number using a range of 0 to 9. If omitted, the default is subsystem 0.
Command Location
Windows | Systemwalker Operation Manager installation directory\MpWalker.JM\bin |
Solaris | /usr/bin |
Output Items
The following explains the items to be output.
Host Name
Host name of the server that executed this command
Sub System
Subsystem number which is corresponding to the Jobscheduler to be operated
Project Name
Name of the project where the job net is registered
Job Net
Name of the job net that is registered in the Jobscheduler
Job Net Comment
Job net comment that is registered in the Jobscheduler
Status
Status of job net
The relevant status is selected from the following eight and displayed:
Normal completion
Pseudo-normal
Abended (completion code: from the upper limit of completion code +1 up to 255)
Canceled (completion code: 256)
Executing
Refused
Interrupted (completion code: 239)
Skipped
Start Time
The date and time the job net started
It is displayed in "month/day/calendar-year hour:minute:second" format.
End Time
The date and time the job net was completed
It is displayed in "month/day/calendar-year hour:minute:second" format.
End Code
Completion code of the job net
Variable Parameter
This is the variable parameter for job nets that were started by specifying a variable parameter. The variable parameter is only displayed if the "-vparam" option was specified.
Caution
From among the log files of the Jobscheduler (jobdb1.log/jobdb2.log/jobdb3.log) that are managed cyclically, this command outputs history information of the current log file and the log file one generation before.
When the Master Schedule Management function is enabled, use the stemprint -g(-G) command to output history information. This command does not output the history information on the process date that has been expired because the generation exceeded the number set in the [Store schedule information for] using the Master Schedule Management function.
For more information on the stemprint -g(-G) command, see "6.12 stemprint -f(-F)/-g(-G) Command."
Output Example
An example output result of this command is shown below.
Host Name,Sub System,Project Name,Job Net,Job Net Comment,Status,Start Time,End Time,End Code, Variable Parameter host1,3,GeneralAffairs,payroll, PayrollAndBonusCalc, Normal,03/01/2014 10:00:01,03/01/2014 11:33:32,0,"200707" host1,3,Sales,backup,BackupJob,Normal,03/01/2014 10:30:01,03/01/2014 11:49:26,0, host1,3,Sales,sales,SalesDataManagement,Normal,03/01/2014 12:48:42,03/01/2014 12:50:56,0,"sales01.dat" host1,3,Sales,management,CustomerManagement,Abend,03/01/2014 13:32:45,03/01/2014 13:42:37,2, host1,3,GeneralAffairs,data,CashierDataManagement, Forced,03/01/2014 16:27:21,03/01/2014 16:31:21,256, host1,3,GeneralAffairs,data,CashierDataManagement, Execute,03/01/2014 16:44:30,,,
When you display the above file in spreadsheet software, you will see a listing similar to:
