PJP Error Logs

The PJP feature of DWD is used to run scheduled ETL Jobs. Every time a PJP job is ran, SQL logs are generated containing the current activity including any errors that may have occurred. The SQL logs only contain the information for the most recent job.

For Example:

A PJP job is ran as a scheduled job or Background job, new jobs are created for each object or step. If an error is encountered when the PJP job is ran on a Saturday, then the errors encountered on that day is displayed in the history of the job. When the PJP job is ran again as scheduled the next day, only the current activity is displayed in the history and the errors encountered on the Saturday run is deleted.

While the error logs from previous jobs are deleted from the current history, the previous error logs are stored in a separate table. To view the error logs from previous PJP jobs, you need to access the PJP_JobErrorLog table.