ETL job monitoring requires the tracking of the start and end of the job. A unit of work is tracked with a unique unit of work identifier (UOW ID) that is passed into the start and end sendevent commands. You can generate a UOW ID by combining information about the job, such as a filename and date and time the job is run, or you can allow the sendevent command to automatically generate a UOW ID.
The general flow for job monitoring is:
- Generate a UOW ID.
- Send a START event.
- [Optional] Send one or more STEP events.
- Send an END event.