SQL Query 6.2 Jobs running in between 2 points of time

[Michael Begler]

I'm looking for a SQL query to see jobs by ID and name that were running at a point in time

jobs would start before 1 am and end after 1 am on the same day

Thank you

[Derrick Au]

Hi Mike,

What type of jobs are these? Are these long running jobs starting before 1am and ending after 1am on the same day? or are these repeating jobs with new or same occurrences?

BR,

Derrick Au