Skip to content
AWS for Query.Farm

aws.m2.get_batch_job_execution

Example SQL Queries

SELECT * FROM
aws.m2.get_batch_job_execution
WHERE
"application_id" = 'VALUE'
AND "execution_id" = 'VALUE';

Description

Gets the details of a specific batch job execution for a specific application.

Table Definition

Column NameColumn Data Type
application_id Required Input Column

The identifier of the application.

VARCHAR
execution_id Required Input Column

The unique identifier for this 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 the batch job execution ended.

TIMESTAMP_S
job_id

The unique identifier for this batch job.

VARCHAR
job_name

The name of this batch job.

VARCHAR
job_step_restart_marker

The restart steps information for the most recent restart operation.

STRUCT(
    "from_proc_step" VARCHAR,
    "from_step" VARCHAR,
    "to_proc_step" VARCHAR,
    "to_step" VARCHAR
)
Show child fields
job_step_restart_marker.from_proc_step

The procedure step name that a job was restarted from.

job_step_restart_marker.from_step

The step name that a batch job restart was from.

job_step_restart_marker.to_proc_step

The procedure step name that a batch job was restarted to.

job_step_restart_marker.to_step

The step name that a job was restarted to.

job_type

The type of job.

VARCHAR
job_user

The user for the job.

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 the batch job execution started.

TIMESTAMP_S
status

The status of the batch job execution.

VARCHAR
status_reason

The reason for the reported status.

VARCHAR