Skip to content

/AWS1/CL_DBR=>DESCRIBEJOBRUN()

About DescribeJobRun

Represents one run of a DataBrew job.

Method Signature

IMPORTING

Required arguments:

iv_name TYPE /AWS1/DBRJOBNAME /AWS1/DBRJOBNAME

The name of the job being processed during this run.

iv_runid TYPE /AWS1/DBRJOBRUNID /AWS1/DBRJOBRUNID

The unique identifier of the job run.

RETURNING

oo_output TYPE REF TO /aws1/cl_dbrdescrjobrunrsp /AWS1/CL_DBRDESCRJOBRUNRSP

Domain /AWS1/RT_ACCOUNT_ID
Primitive Type NUMC

Examples

Syntax Example

This is an example of the syntax for calling the method. It includes every possible argument and initializes every possible value. The data provided is not necessarily semantically accurate (for example the value "string" may be provided for something that is intended to be an instance ID, or in some cases two arguments may be mutually exclusive). The syntax shows the ABAP syntax for creating the various data structures.

DATA(lo_result) = lo_client->/aws1/if_dbr~describejobrun(
  iv_name = |string|
  iv_runid = |string|
).

This is an example of reading all possible response values

lo_result = lo_result.
IF lo_result IS NOT INITIAL.
  lv_attempt = lo_result->get_attempt( ).
  lv_date = lo_result->get_completedon( ).
  lv_datasetname = lo_result->get_datasetname( ).
  lv_jobrunerrormessage = lo_result->get_errormessage( ).
  lv_executiontime = lo_result->get_executiontime( ).
  lv_jobname = lo_result->get_jobname( ).
  lo_profileconfiguration = lo_result->get_profileconfiguration( ).
  IF lo_profileconfiguration IS NOT INITIAL.
    lo_statisticsconfiguration = lo_profileconfiguration->get_datasetstatisticsconf( ).
    IF lo_statisticsconfiguration IS NOT INITIAL.
      LOOP AT lo_statisticsconfiguration->get_includedstatistics( ) into lo_row.
        lo_row_1 = lo_row.
        IF lo_row_1 IS NOT INITIAL.
          lv_statistic = lo_row_1->get_value( ).
        ENDIF.
      ENDLOOP.
      LOOP AT lo_statisticsconfiguration->get_overrides( ) into lo_row_2.
        lo_row_3 = lo_row_2.
        IF lo_row_3 IS NOT INITIAL.
          lv_statistic = lo_row_3->get_statistic( ).
          LOOP AT lo_row_3->get_parameters( ) into ls_row_4.
            lv_key = ls_row_4-key.
            lo_value = ls_row_4-value.
            IF lo_value IS NOT INITIAL.
              lv_parametervalue = lo_value->get_value( ).
            ENDIF.
          ENDLOOP.
        ENDIF.
      ENDLOOP.
    ENDIF.
    LOOP AT lo_profileconfiguration->get_profilecolumns( ) into lo_row_5.
      lo_row_6 = lo_row_5.
      IF lo_row_6 IS NOT INITIAL.
        lv_columnname = lo_row_6->get_regex( ).
        lv_columnname = lo_row_6->get_name( ).
      ENDIF.
    ENDLOOP.
    LOOP AT lo_profileconfiguration->get_columnstatisticsconfs( ) into lo_row_7.
      lo_row_8 = lo_row_7.
      IF lo_row_8 IS NOT INITIAL.
        LOOP AT lo_row_8->get_selectors( ) into lo_row_5.
          lo_row_6 = lo_row_5.
          IF lo_row_6 IS NOT INITIAL.
            lv_columnname = lo_row_6->get_regex( ).
            lv_columnname = lo_row_6->get_name( ).
          ENDIF.
        ENDLOOP.
        lo_statisticsconfiguration = lo_row_8->get_statistics( ).
        IF lo_statisticsconfiguration IS NOT INITIAL.
          LOOP AT lo_statisticsconfiguration->get_includedstatistics( ) into lo_row.
            lo_row_1 = lo_row.
            IF lo_row_1 IS NOT INITIAL.
              lv_statistic = lo_row_1->get_value( ).
            ENDIF.
          ENDLOOP.
          LOOP AT lo_statisticsconfiguration->get_overrides( ) into lo_row_2.
            lo_row_3 = lo_row_2.
            IF lo_row_3 IS NOT INITIAL.
              lv_statistic = lo_row_3->get_statistic( ).
              LOOP AT lo_row_3->get_parameters( ) into ls_row_4.
                lv_key = ls_row_4-key.
                lo_value = ls_row_4-value.
                IF lo_value IS NOT INITIAL.
                  lv_parametervalue = lo_value->get_value( ).
                ENDIF.
              ENDLOOP.
            ENDIF.
          ENDLOOP.
        ENDIF.
      ENDIF.
    ENDLOOP.
    lo_entitydetectorconfigura = lo_profileconfiguration->get_entitydetectorconf( ).
    IF lo_entitydetectorconfigura IS NOT INITIAL.
      LOOP AT lo_entitydetectorconfigura->get_entitytypes( ) into lo_row_9.
        lo_row_10 = lo_row_9.
        IF lo_row_10 IS NOT INITIAL.
          lv_entitytype = lo_row_10->get_value( ).
        ENDIF.
      ENDLOOP.
      LOOP AT lo_entitydetectorconfigura->get_allowedstatistics( ) into lo_row_11.
        lo_row_12 = lo_row_11.
        IF lo_row_12 IS NOT INITIAL.
          LOOP AT lo_row_12->get_statistics( ) into lo_row.
            lo_row_1 = lo_row.
            IF lo_row_1 IS NOT INITIAL.
              lv_statistic = lo_row_1->get_value( ).
            ENDIF.
          ENDLOOP.
        ENDIF.
      ENDLOOP.
    ENDIF.
  ENDIF.
  LOOP AT lo_result->get_validationconfigurations( ) into lo_row_13.
    lo_row_14 = lo_row_13.
    IF lo_row_14 IS NOT INITIAL.
      lv_arn = lo_row_14->get_rulesetarn( ).
      lv_validationmode = lo_row_14->get_validationmode( ).
    ENDIF.
  ENDLOOP.
  lv_jobrunid = lo_result->get_runid( ).
  lv_jobrunstate = lo_result->get_state( ).
  lv_logsubscription = lo_result->get_logsubscription( ).
  lv_loggroupname = lo_result->get_loggroupname( ).
  LOOP AT lo_result->get_outputs( ) into lo_row_15.
    lo_row_16 = lo_row_15.
    IF lo_row_16 IS NOT INITIAL.
      lv_compressionformat = lo_row_16->get_compressionformat( ).
      lv_outputformat = lo_row_16->get_format( ).
      LOOP AT lo_row_16->get_partitioncolumns( ) into lo_row_17.
        lo_row_18 = lo_row_17.
        IF lo_row_18 IS NOT INITIAL.
          lv_columnname = lo_row_18->get_value( ).
        ENDIF.
      ENDLOOP.
      lo_s3location = lo_row_16->get_location( ).
      IF lo_s3location IS NOT INITIAL.
        lv_bucket = lo_s3location->get_bucket( ).
        lv_key_1 = lo_s3location->get_key( ).
        lv_bucketowner = lo_s3location->get_bucketowner( ).
      ENDIF.
      lv_overwriteoutput = lo_row_16->get_overwrite( ).
      lo_outputformatoptions = lo_row_16->get_formatoptions( ).
      IF lo_outputformatoptions IS NOT INITIAL.
        lo_csvoutputoptions = lo_outputformatoptions->get_csv( ).
        IF lo_csvoutputoptions IS NOT INITIAL.
          lv_delimiter = lo_csvoutputoptions->get_delimiter( ).
        ENDIF.
      ENDIF.
      lv_maxoutputfiles = lo_row_16->get_maxoutputfiles( ).
    ENDIF.
  ENDLOOP.
  LOOP AT lo_result->get_datacatalogoutputs( ) into lo_row_19.
    lo_row_20 = lo_row_19.
    IF lo_row_20 IS NOT INITIAL.
      lv_catalogid = lo_row_20->get_catalogid( ).
      lv_databasename = lo_row_20->get_databasename( ).
      lv_tablename = lo_row_20->get_tablename( ).
      lo_s3tableoutputoptions = lo_row_20->get_s3options( ).
      IF lo_s3tableoutputoptions IS NOT INITIAL.
        lo_s3location = lo_s3tableoutputoptions->get_location( ).
        IF lo_s3location IS NOT INITIAL.
          lv_bucket = lo_s3location->get_bucket( ).
          lv_key_1 = lo_s3location->get_key( ).
          lv_bucketowner = lo_s3location->get_bucketowner( ).
        ENDIF.
      ENDIF.
      lo_databasetableoutputopti = lo_row_20->get_databaseoptions( ).
      IF lo_databasetableoutputopti IS NOT INITIAL.
        lo_s3location = lo_databasetableoutputopti->get_tempdirectory( ).
        IF lo_s3location IS NOT INITIAL.
          lv_bucket = lo_s3location->get_bucket( ).
          lv_key_1 = lo_s3location->get_key( ).
          lv_bucketowner = lo_s3location->get_bucketowner( ).
        ENDIF.
        lv_databasetablename = lo_databasetableoutputopti->get_tablename( ).
      ENDIF.
      lv_overwriteoutput = lo_row_20->get_overwrite( ).
    ENDIF.
  ENDLOOP.
  LOOP AT lo_result->get_databaseoutputs( ) into lo_row_21.
    lo_row_22 = lo_row_21.
    IF lo_row_22 IS NOT INITIAL.
      lv_glueconnectionname = lo_row_22->get_glueconnectionname( ).
      lo_databasetableoutputopti = lo_row_22->get_databaseoptions( ).
      IF lo_databasetableoutputopti IS NOT INITIAL.
        lo_s3location = lo_databasetableoutputopti->get_tempdirectory( ).
        IF lo_s3location IS NOT INITIAL.
          lv_bucket = lo_s3location->get_bucket( ).
          lv_key_1 = lo_s3location->get_key( ).
          lv_bucketowner = lo_s3location->get_bucketowner( ).
        ENDIF.
        lv_databasetablename = lo_databasetableoutputopti->get_tablename( ).
      ENDIF.
      lv_databaseoutputmode = lo_row_22->get_databaseoutputmode( ).
    ENDIF.
  ENDLOOP.
  lo_recipereference = lo_result->get_recipereference( ).
  IF lo_recipereference IS NOT INITIAL.
    lv_recipename = lo_recipereference->get_name( ).
    lv_recipeversion = lo_recipereference->get_recipeversion( ).
  ENDIF.
  lv_startedby = lo_result->get_startedby( ).
  lv_date = lo_result->get_startedon( ).
  lo_jobsample = lo_result->get_jobsample( ).
  IF lo_jobsample IS NOT INITIAL.
    lv_samplemode = lo_jobsample->get_mode( ).
    lv_jobsize = lo_jobsample->get_size( ).
  ENDIF.
ENDIF.