Transform - Job Tasks Enhancements


Then looking at the Job, one should be able to see the current task information.


This will allow understanding where in the process a job is.  In addition, this permits the error message to be displayed on the Monitor page when a job fails.



This change can be implemented by addding TaskID to webQueueTaskLogHor


Then creating a view based on that that takes the MIN(TaskID) where Status is Not Completed.

Lastly, win WebQueueLogHor, outerjoin to the view mentioned with the MIN (On jobId and task), then Inner join that to webqueuetaskloghor.]


This requirement was discovered at Lidl - Ireland, Northern Ireland Implementation when we had jobs fail repeatedly and it took too long to identify the error message.

  • Guest
  • Jan 31 2017
  • Shipped
  • Attach files
  • +1