select taskURL, runTime, alertThresholdMins, initialRunTime, runCount, taskName, case when alertThresholdMins = 0 then 'N' else case when datediff( minute, runTime, ) > alertThresholdMins then 'Y' else 'N' end end flagged, case when alertThresholdMins > 0 then dateadd( minute, alertThresholdMins, runTime ) else runtime end nextRunTime, case when alertThresholdMins > 0 then 'N' else 'Y' end newTask from tbl_SYS_SchedulerLog where taskurl not like '%http://fseweb03.appslibrary.com%' and taskurl not like '%http://fseweb04.appslibrary.com%' order by flagged desc, newTask, nextRunTime

Late	Task	Last Run	Run Count	Cycle	Next Run
#flagged#?	#htmleditformat( taskName )##htmleditformat( taskURL )#	#lsdateformat( runTime, "mmm d")# @ #lstimeformat( runTime )#	#lsNumberformat( runCount )#	#lsnumberformat( _cycleCount )##_cycleUnit# ?	#lsdateformat( nextRunTime, "mmm dd")# @ #lstimeformat( nextRunTime )#?