This section explains the operation record file output by Job Execution Control.
What is the operation record files?
The operation record file is the file in which the operation information about the executed jobs and job nets is logged in CSV format. To collect operation records, designate so in the [Logging] sheet of the [Define Operating Information] window.
The following three types of records are output in the CSV format to the operation record file.
Service Record
Job Record
Step Record
For the information output to these records, see "18.1.1.1 Service Record", "18.1.1.2 Job Record", and "18.1.1.3 Step Record".
Note
Referencing Operation Record File
An attempt to write the operation record file being opened in an application such as Microsoft Excel when the Job Execution Control service is in execution may result in a failure.
Note
Record outputs in network jobs
Record outputs in network jobs are shown below.
The execution host name is output to a step record of the step completion event.
The execution host name is output to a job record of the step completion event.
Note
Queue name and job name
Following are notes on the information output to queue name and job name.
The queue names output to the job record of a job submission event are identical to those output to the job record of a job completion event.
If the JCL is submitted from a job folder, the qsub command or an environment not under control of folders, a job file name without its path and extension is regarded as the job name. The job names written in jobstart statements are ignored.
Output Conventions
The conventions for the operation record outputs are as follows.
A line break is output for each record and one line is treated as one record.
A comma "," is output to separate data.
If the data type is string, it is enclosed in double quotes (""). When double quotes already exist within the string, two double quotes are output consecutively.
If the data type is numeric, it is not enclosed in double quotes but is output as it is.
Date and time data is output as strings.
The maximum number of character strings for one operation record is limited up to 2048 bytes.
If the output data is date or time, actual examples are given.
This record is output at the startup and stop of the Systemwalker MpMjes service.
No. | Data Item | Value (Fixed/Variable) | Output Data | Data Format |
|---|---|---|---|---|
1 | Record creation date | Variable | "01/01/2000" | String |
2 | Record creation time | Variable | "01:01:01" | String |
3 | Record type | Fixed | 1 | Numeric |
4 | Host name | Variable | "Host name" | String |
5 | Version information | Variable | "Version/level" (Note 1) | String |
6 | Startup or Stop | Variable | "START": Startup "STOP": Stop | String |
7 | Startup mode (Note 2) | Variable | "COLD": Initialization mode "WARM": Continuation mode "RECOVERY": Recovery mode | String |
8 | Operation mode (Note 2) | Variable | "CANCEL": Disable continuation mode "CONTINUE": Enable continuation mode | String |
The current version/level name in use is output.
The startup and operation modes are output only when Startup or Stop is set to "START."
The job record consists of a fixed part and a variable part. The fixed and variable parts are merged and output as one record.
The variable part changes according to the event type associated with the job. There are the following types of variable parts:
Output when the job is submitted.
Output when the job execution starts.
Output when the job execution completes.
Output when the job is deleted from the server where Systemwalker Operation Manager was installed.
Output after job start event is output when the job execution is requested to another host since the job execution request failed.
No. | Data Item | Value (Fixed/Variable) | Output Data | Data Format |
|---|---|---|---|---|
1 | Record creation date | Variable | "01/01/2000" | String |
2 | Record creation time | Variable | "01:01:01" | String |
3 | Record type | Fixed | 2 | Numeric |
4 | Host name | Variable | "Host name" | String |
5 | Version information | Variable | "Version/level" (Note 1) | String |
6 | Job name | Variable | "Job name" | String |
7 | Job number | Variable | NN | Numeric |
8 | User name | Variable | "User name" | String |
9 | Event type | Variable | 0: Job submission event 1: Job start event 2: Job completion event 3: Job delete event 4. Job restart event | Numeric |
10 | Submission source host name | Variable | "Submission source host name" | String |
11 | Job type | Variable | 0: Local job (Note 2) 1: Network job (Note 2) 2: Load-sharing job (Note 3) | Numeric |
12 | Job attribute | Variable | 0: General job 2: NJS job 3: GLOVIA job 4 :GLOVIA-BO 7: Online job | Numeric |
The current version/level name in use is output.
When a job is executed locally under distributed execution, "0: Local job" is output and when executed on another host, "1: Network job" is output.
Load-balancing of compatibility with older version is output only for Windows.
No. | Data Item | Value (Fixed/Variable) | Output Data | Data Format |
|---|---|---|---|---|
1 | Job submission date | Variable | "01/01/2000" | String |
2 | Job submission time | Variable | "01:01:00" | String |
3 | Client host name | Variable | "Client host name" | String |
4 | Queue name | Variable | "Queue name" | String |
5 | Command name (Note 1) | Variable | "Command argument" | String |
6 | Project name | Variable | "SampleProject" | String |
7 | Job net name | Variable | "Sample" | String |
The name and argument of command submitted as a job is output as a command name.
No. | Data Item | Value (Fixed/Variable) | Output Data | Data Format |
|---|---|---|---|---|
1 | Job start date | Variable | "01/01/2000" | String |
2 | Job start time | Variable | "01:01:01" | String |
No. | Data Item | Value (Fixed/Variable) | Output Data | Data Format |
|---|---|---|---|---|
1 | Job completion date | Variable | "01/01/2000" | String |
2 | Job completion time | Variable | "01:01:02" | String |
3 | Execution host name | Variable | "Execution host name" | String |
4 | Job completion code (Note 1) | Variable | NN | Numeric |
5 | Number of job steps | Variable | NN | Numeric |
6 | Queue name | Variable | "Queue name" | String |
7 | Elapsed time for execution (Note 2) | Variable | NN | Numeric |
8 | Time lapse limit (Notes 2 and 3) | Variable | NN | Numeric |
9 | Estimated processing time (Notes 2 and 3) | Variable | NN | Numeric |
10 | The ID of the first process of the job (Note 4) | Variable | NN | Numeric |
When multiple steps have been executed, the largest completion code among those for the completed steps is output.
Output in seconds.
A 0 is output when it has not been specified when a queue was defined or a job was submitted.
-1 is output for network job and JCL.
No. | Data Item | Value (Fixed/Variable) | Output Data | Data Format |
|---|---|---|---|---|
1 | Job delete date | Variable | "01/01/2000" | String |
2 | Job delete time | Variable | "01:01:03" | String |
No. | Data Item | Value (Fixed/Variable) | Output Data | Data Format |
|---|---|---|---|---|
1 | Job restart date | Variable | "01/01/2000" | String |
2 | Job restart time | Variable | "01:01:03" | String |
The step record consists of a fixed part and a variable part. The fixed and variable parts are merged and output as one record.
The variable part changes according to the event type associated with the step. There are the following types of variable parts:
Output when a JCL file step is started.
Output when a JCL file step completes.
No. | Data Item | Value (Fixed/Variable) | Output Data | Data Format |
|---|---|---|---|---|
1 | Record creation date | Variable | "01/01/2000" | String |
2 | Record creation time | Variable | "01:01:01" | String |
3 | Record type | Fixed | 3 | Numeric |
4 | Host name | Variable | "Host name" | String |
5 | Version information | Variable | "Version/level" (Note 1) | String |
6 | Job name | Variable | "Job name" | String |
7 | Job number | Variable | NN | Numeric |
8 | Event type | Variable | 0: Step start event 1: Step completion event | Numeric |
9 | Step name | Variable | "Step name" | String |
10 | Step number | Variable | NN | Numeric |
The current version/level name in use is output.
No. | Data Item | Value (Fixed/Variable) | Output Data | Data Format |
|---|---|---|---|---|
1 | Step start date | Variable | "01/01/2000" | String |
2 | Step start time | Variable | "01:01:01" | String |
No. | Data Item | Value (Fixed/Variable) | Output Data | Data Format |
|---|---|---|---|---|
1 | Step completion date | Variable | "01/01/2000" | String |
2 | Step completion time | Variable | "01:01:02" | String |
3 | Execution host name | Variable | "Execution host name" | String |
4 | Step completion code | Variable | NN | Numeric |
