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 live online training, plus books, videos, and digital content from nearly 200 publishers.