| Column Name | Column Data Type |
|---|
application_id Required Input Column
The unique identifier of the application that hosts this batch job. | VARCHAR |
execution_ids Input Column
The unique identifier of each batch job execution. | VARCHAR[] |
Show child fields- execution_ids[]
|
job_name Input Column
The name of a particular batch job. | VARCHAR |
started_after Input Column
The time after which the batch job executions started. | TIMESTAMP_S |
started_before Input Column
The time before the batch job executions started. | TIMESTAMP_S |
status Input Column
The status of a particular batch job execution. | VARCHAR |
_aws_profile Input Column
The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role. | STRUCT(
"type" VARCHAR,
"name" VARCHAR,
"account_id" VARCHAR,
"via_profile_name" VARCHAR,
"assumed_role_arn" VARCHAR,
"organization" STRUCT(
"account_name" VARCHAR,
"id" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[],
"master_account" STRUCT(
"id" VARCHAR,
"email" VARCHAR
),
"parents" STRUCT(
"type" VARCHAR,
"id" VARCHAR,
"name" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[]
)[]
)
) |
Show child fields- _aws_profile.account_id
The AWS account id - _aws_profile.assumed_role_arn
The ARN of the assumed role - _aws_profile.name
The unique name of the profile. - _aws_profile.organization
Information about this profile's membership in the AWS organization. Show child fields- _aws_profile.organization.account_name
The name of account speciifed by the organization - _aws_profile.organization.id
The organization id - _aws_profile.organization.master_account
Show child fields- _aws_profile.organization.master_account.email
The organization master account email address - _aws_profile.organization.master_account.id
The organization master account id
- _aws_profile.organization.parents[]
Show child fields- _aws_profile.organization.parents[].id
The id of the parent - _aws_profile.organization.parents[].name
The name of the parent - _aws_profile.organization.parents[].tags[]
Show child fields- _aws_profile.organization.parents[].tags[].key
- _aws_profile.organization.parents[].tags[].value
- _aws_profile.organization.parents[].type
The type of parent can be an organization unit or a root
- _aws_profile.organization.tags[]
Show child fields- _aws_profile.organization.tags[].key
- _aws_profile.organization.tags[].value
- _aws_profile.type
The type of profile, either 'credentials' or 'assumed_role' - _aws_profile.via_profile_name
This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.
|
_aws_region Input Column
The AWS region to use. | VARCHAR |
batch_job_identifier
The unique identifier of this batch job. | STRUCT(
"file_batch_job_identifier" STRUCT(
"file_name" VARCHAR,
"folder_path" VARCHAR
),
"restart_batch_job_identifier" STRUCT(
"execution_id" VARCHAR,
"job_step_restart_marker" STRUCT(
"from_proc_step" VARCHAR,
"from_step" VARCHAR,
"to_proc_step" VARCHAR,
"to_step" VARCHAR
)
),
"s3_batch_job_identifier" STRUCT(
"bucket" VARCHAR,
"identifier" STRUCT(
"file_name" VARCHAR,
"script_name" VARCHAR
),
"key_prefix" VARCHAR
),
"script_batch_job_identifier" STRUCT(
"script_name" VARCHAR
)
) |
Show child fields- batch_job_identifier.file_batch_job_identifier
Specifies a file associated with a specific batch job. Show child fields- batch_job_identifier.file_batch_job_identifier.file_name
The file name for the batch job identifier. - batch_job_identifier.file_batch_job_identifier.folder_path
The relative path to the file name for the batch job identifier.
- batch_job_identifier.restart_batch_job_identifier
Specifies the required information for restart, including execution ID and jobsteprestartmarker. Show child fields- batch_job_identifier.restart_batch_job_identifier.execution_id
The executionId from the StartBatchJob response when the job ran for the first time. - batch_job_identifier.restart_batch_job_identifier.job_step_restart_marker
The restart step information for the most recent restart operation. Show child fields- batch_job_identifier.restart_batch_job_identifier.job_step_restart_marker.from_proc_step
The procedure step name that a job was restarted from. - batch_job_identifier.restart_batch_job_identifier.job_step_restart_marker.from_step
The step name that a batch job restart was from. - batch_job_identifier.restart_batch_job_identifier.job_step_restart_marker.to_proc_step
The procedure step name that a batch job was restarted to. - batch_job_identifier.restart_batch_job_identifier.job_step_restart_marker.to_step
The step name that a job was restarted to.
- batch_job_identifier.s3_batch_job_identifier
Specifies an Amazon S3 location that identifies the batch jobs that you want to run. Use this identifier to run ad hoc batch jobs. Show child fields- batch_job_identifier.s3_batch_job_identifier.bucket
The Amazon S3 bucket that contains the batch job definitions. - batch_job_identifier.s3_batch_job_identifier.identifier
Identifies the batch job definition. This identifier can also point to any batch job definition that already exists in the application or to one of the batch job definitions within the directory that is specified in keyPrefix. Show child fields- batch_job_identifier.s3_batch_job_identifier.identifier.file_name
The name of the file that contains the batch job definition. - batch_job_identifier.s3_batch_job_identifier.identifier.script_name
The name of the script that contains the batch job definition.
- batch_job_identifier.s3_batch_job_identifier.key_prefix
The key prefix that specifies the path to the folder in the S3 bucket that has the batch job definitions.
- batch_job_identifier.script_batch_job_identifier
A batch job identifier in which the batch job to run is identified by the script name. Show child fields- batch_job_identifier.script_batch_job_identifier.script_name
The name of the script containing the batch job definition.
|
end_time
The timestamp when this batch job execution ended. | TIMESTAMP_S |
execution_id
The unique identifier of this execution of the batch job. | VARCHAR |
job_id
The unique identifier of a particular batch job. | VARCHAR |
job_type
The type of a particular batch job execution. | VARCHAR |
return_code
The batch job return code from either the Blu Age or Micro Focus runtime engines. For more information, see Batch return codes in the IBM WebSphere Application Server documentation. | VARCHAR |
start_time
The timestamp when a particular batch job execution started. | TIMESTAMP_S |