Hope that each pro has more principles.

Here's some example to get basic job history information for rolling month. It was passed to me, hope this help!

SELECT

JobName,

ROW_NUMBER() OVER(PARTITION BY...