Forum Discussion
RiaanBadenhorst
9 years agoLevel 6
Hello
Simply add this to your query and change the 24 to the value you require. It reflects the time difference from NOW to the jobs end time.
In otherwords, if you run the report at 23:00 and you use 2 as your value, it will show you all the jobs that completed in the last 2 hours.
AND DATEDIFF(hour,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <= 24
Related Content
- 8 months ago
- 5 years ago
- 11 months ago