Monitoring job execution

In this recipe, we will take a closer look at the job execution parameters, tracing options, and job monitoring techniques.

Getting ready

We will use the job we developed in the previous chapters, Job_DWH_DimGeography, to see how the job execution can be traced and monitored.

Let's perform minor changes to the job to prepare the job for the recipe examples using these steps:

  1. On the job-level context, create a global variable, $g_RunDate, of the date data type and assign the sysdate() function to it as a value.
  2. At the same job level, before the sequence of workflows, place a new script object with the following code and link it to the first workflow. This script will be the first object executed within a job:
    print('*************************************************'); ...

Get SAP Data Services 4.x Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.