In this recipe, we will take a closer look at the job execution parameters, tracing options, and job monitoring techniques.
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:
On the job-level context, create a global variable,
$g_RunDate,
of the date data type and assign thesysdate()
function to it as a value.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('*************************************************'); print('INFO: Job '||job_name()||' started on '||$g_RunDate); print('*************************************************');