Sort order in Scheduled Jobs window

Question

We are running NCM 5.1.1. In the "Scheduled Jobs" window/tab, I can click on the "Schedule" column heading to sort based on that field, but it then sorts on that as a text string, not a date. So, for instance, in an ascending sort, you'll get this order:

2:00 AM

2:30 PM

3:00 AM

And dates are ignored completely, so if I want to look at scheduled jobs completed in the last month, I have no way of sorting the list to get that..

Would it be possible to treat this field as an actual date/time, and sort on that basis?

GeorgeK · Answer

Thanks for the reply, Chris.

Unfortunately, both "Next Run" and "Last Run" are also sorted as strings, not as dates.

chris.lapoint · Answer

Hi George, thanks for the post.  I'll add this to our tracking system.

In the interim, you might try adding the column for "Next Run" and sorting on that.   I believe it may get you closer to the results you are looking for.