Synopsis
jobschdeftocsv [-d] control statement file
Description
The jobschdeftocsv command converts the following control statement files into the CSV format file. The conversion result is output in standard output.
Job net control statements and job control statements
Group control statements and group job net control statements
Holiday information control statements
Schedule pattern control statements
Saving the conversion result in a file enables the control statement information to be managed in spreadsheet software. (Note)
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
-d
Items are enclosed in double quotes (") when they are output. The double quote character itself is output as two consecutive double quotes ("").
Specify this option if necessary when importing the output results into a spreadsheet program if a control statement includes double quotes.
Without the "-d" option: a"b
With the "-d" option: "a""b"
Control statement file
Specifies the control statement file to be converted. The files for the following control statement can be specified:
Job net control and job control statements
Group control and group job net control statements
Holiday information control statements
Schedule pattern control statements
To get the control statement file that is specified using this command, use the output result of the jobschprint -r/-R/-rh/-rsp command, or create it by following the example below.
- Example of creating a control statement file for job net control statement file and job control statements
An example of control statement file for the job net control statements and job control statements is shown below. For details of each control statement, see "4.9.1 Job Net Control Statement" and "4.9.2 Job Control Statement".
NET jobnetname selling jobnetcomment SalesManagement starttime 2000 execpattern EveryFriday holidayshift IGN defaulthost king job 4 operate PAUSE ; JOB jobname management1 jobnumber 1 jobcomment CustomerInquiry restartpoint ON iconposition 1,1 operate NONE ; JOB jobname management2 jobnumber 2 jobcomment CreditDetails pre_job 1 iconposition 1,2 operate NONE ; JOB jobname management3 jobnumber 3 jobcomment DataSearch pre_job 1 iconposition 2,2 operate DISABLE ; JOB jobname management4 jobnumber 4 jobcomment Backup pre_job 2,3 iconposition 1,3 operate NONE ;
- Example of creating a control statement file for group control statements and group job net control statements
An example of control statement file for the group control statements and group job net control statements is shown below. For details of each control statement, see "4.10.1 Group Control Statement" and "4.10.2 Group Job Net Control Statement".
GRP groupname weeklyreport groupcomment WeeklyReport jobnet 2 ; GNT jobnetname sales jobnetnumber 1 ; GNT jobnetname selling jobnetnumber 2 pre_jobnet 1 ;
- Example of creating a control statement file for holiday information control statements
An example of a control statement file for holiday information control statements is shown below. Refer to "4.2.1 Holiday Information Control Statement" for details about the control statements.
HOL |
- Example of creating a control statement file for schedule pattern control statements
An example of a control statement file for schedule pattern control statements is shown below. Refer to "4.3.1 Schedule Pattern Control Statement" for details about the control statements.
CAL |
Command Location
Windows | Systemwalker Operation Manager installation directory\MpWalker.JM\bin |
Solaris | /usr/bin |
Cautions
When loading a CSV format file into spreadsheet software, the string that contains only numbers (no letters) may be converted as follows:
From: "0010" (Notation in CSV file)
To: "10" (Notation in spreadsheet software)
This problem occurs due to an error that the spreadsheet software recognizes the string with only numbers (no letters) as numerical data, rather than as the character string. In such a case, first change the format setting of the cell so that the relevant cell is treated as a character string, then correct the character string to match the notation in the CSV file.
Output Example
The following is an output example when you enter the control statement files shown in the above examples to create a control statement file.
- Output example of information on job net control statements and job control statements.
NET jobnetname,jobnetcomment,starttime,execpattern,holidayshift,defaulthost,job,operate selling,SalesManagement,2000,EveryFriday,IGN,king,4,PAUSE JOB jobname,jobnumber,jobcomment,restartpoint,pre_job,iconposition,operate management1,1,CustomerInquiry,ON,1;1,NONE management2,2,CreditDetails,,1,1;2, NONE management3,3,DataSearch,,1,2;2,DISABLE management4,4,Backup,,2;3,1;3,NONE
- Output example of information on group control statements and group job net control statements
GRP groupname,groupcomment,jobnet weeklyreport,WeeklyReport,2 GNT jobnetname,jobnetnumber,pre_jobnet sales,1, selling,2,1
- Output example of the holiday information control statement information
HOL |
- Output example of the schedule pattern control statement information
CAL |
The above contents will appear in the following format if you display them in the spreadsheet software:
- Display example of information on job net control statements and job control statements
NET | |||||||
jobnetname | jobnetcomment | starttime | execpattern | holidayshift | defaulthost | job | operate |
selling | SalesManagement | 2000 | EveryFriday | IGN | king | 4 | PAUSE |
JOB | |||||||
jobname | jobnumber | jobcomment | restartpoint | pre_job | iconposition | operate | |
management1 | 1 | CustomerInquiry | ON | 1;1 | NONE | ||
management2 | 2 | CreditDetails | 1 | 1;2 | NONE | ||
management3 | 3 | DataSearch | 1 | 2;2 | DISABLE | ||
management4 | 4 | Backup | 2;3 | 1;3 | NONE |
- Display example of information on group control statements and group job net control statements
GRP | ||
groupname | groupcomment | jobnet |
weeklyreport | WeeklyReport | 2 |
GNT | ||
jobnetname | jobnetnumber | pre_jobnet |
sales | 1 | |
selling | 2 | 1 |
- Display example of information on holiday information control statements
HOL | ||||||
calendarname | yearset | monthset | dayset | yearset | monthset | dayset |
MainOfficeCalendar | 2010 | 11 | 1 | 2010 | 12 | 20 |
- Display example of information on schedule pattern control statements
CAL | ||||
execpatname | monthset | dayset | monthset | dayset |
Sample | 1 | 1 | 2 | 10 |
