JOBS.AVALOQAGENT.SHOWBASETABLE

{"URL":["/*.*/awa/pa_view_sheet_showbasetable_avaloq"],"heroDescriptionIdentifier":"ice_hero_SHOWBASETABLE","customCards":[{"id":"ice_connecting_Jobs","title":"Adding the Connection Section","type":"customize","url":"https://docs.automic.com/documentation/webhelp/english/ALL/components/IG_AVALOQ/*.*/Agent%20Guide/Content/AVALOQ/AVALOQ_SHOWBASETABLE.htm","languages":["en-us"]},{"id":"ice_SHOWBASETABLE_Avaloq","title":"Defining the Show Content of Avaloq BASE Table Section","type":"customize","url":"https://docs.automic.com/documentation/webhelp/english/ALL/components/IG_AVALOQ/*.*/Agent%20Guide/Content/AVALOQ/AVALOQ_SHOWBASETABLE.htm","languages":["en-us"]},{"id":"ice_RA_Integration_Report","title":"RA / Integration Reports","type":"customize","url":"https://docs.automic.com/documentation/webhelp/english/ALL/components/IG_AVALOQ/*.*/Agent%20Guide/Content/AVALOQ/AVALOQ_Reports.htm","languages":["en-us"]},{"id":"ice_three_SHOWBASETABLE_script","title":"Setting Job Properties through Scripts","type":"customize","url":"https://docs.automic.com/documentation/webhelp/english/ALL/components/IG_AVALOQ/*.*/Agent%20Guide/Content/AVALOQ/AVALOQ_Scripting_Attributes.htm","languages":["en-us"]},{"id":"ice_related_information_SHOWBASETABLE","title":"Related Information","type":"customize","url":"https://docs.automic.com/documentation/webhelp/english/ALL/components/IG_AVALOQ/*.*/Agent%20Guide/Content/AVALOQ/AVALOQ_SHOWBASETABLE.htm","languages":["en-us"]}]}

On the Show BASE Table page you define the parameters relevant to run that job on the Avaloq system from Automic Automation.

As an administrator, you create and execute a JOBS.AVALOQAGENT.SHOWBASETABLE job to extract the content of the AvaloqOracle BASE table for a specific Business Unit. After executing this job, the content of the BASE table is written to the job report. The resulting job report contains some general information at the beginning. The actual content of the BASE table is written after the Start Output label.

Tip:

You can configure the job to also create a Post Process report with the content of the BASE table only (without the initial general information). To do so, write a script on the job Post Process page and use the PREP_PROCESS_REPORT script statement.

For more information about this script statement, please refer to the Automic System product documentation at docs.automic.com (Reference > Automation Engine Script Reference > Scripts Elements Ordered by Purpose > Data Sequences > PREP_PROCESS_REPORT).

This page includes the following:

Defining the Connection Settings

Each Avaloq Job includes a section that you use to connect:

  • Avaloq Instance

    Select the Connection object that will establish the communication between the Automation Engine and your Avaloq system.

Defining the Show BASE Table Section

In the Show Content of Avaloq BASE Table section, you define the parameters relevant to run that job on the Avaloq system from Automic Automation

  • Business Unit ID

    Integer that identifies the Business Unit.

    Enter -1 for Sentinel in Business Unit ID.

  • Table Columns

    Database tables (fields and values) whose content you want to retrieve. Enter the name of the tables separated by a comma without spaces. For example:

    TODAY,EOD_STATUS_ID,EOD_START,EOD_END

Next Steps

Once you have defined the SHOWBASETABLE Job, you can execute and monitor it. You can add it to other Automic Automation objects, such as Workflows or Schedules to orchestrate and automate its execution. For information about Automic Automation Workflows, Schedules and so forth, see Object Types in the Automic Automation product documentation.

Go to the Rapid Automation tab to configure the job reporting options. For more information, see Monitoring Avaloq Jobs, Reports and Optional Reports.

Optionally, go to the Process > Post Process page and enter a script to create a Post Process report with just the content of the table.

Note:

Instead of selecting the job parameters in their respective pages, you can specify them on the Process page using the Automation Engine scripting language. You use the :PUT_ATT script statement for this purpose. For example:

:PUT_ATT AVConnectionValue = "CONN.AVALOQAGENT.C1V00001"

:PUT_ATT AVBUValue = 9

:PUT_ATT AVtblFieldsValue = "TODAY,EOD,START,EOD_END"

For more information, see Setting Avaloq Job Parameters Using Variables and Automation Engine Scripting.

After selecting the Connection and Agent, click the Execute button in the toolbar.

You have the following options to check the result of the execution:

  • Click the Open Report link in the pop up that is displayed after executing the job

  • Go back to the Explorer list and right-click the job to select Monitoring > Last Report.

Example

This is what a job report looks like:

Starting ShowBaseTable

Reported Fields: TODAY,EOD_STATUS_ID,EOD_START,EOD_END

Number of Fields: 4

Business Unit: 9

Start Output

TODAY: 2020-09-02 00:00:00

EOD_STATUS_ID: 502

EOD_START: 2020-04-04 09:43:01.0 CET

EOD_END: 2020-04-04 09:43:32.0 CET

See also: