On Oct 26, 2006, at 6:44 AM, Gopinathan, Srinath wrote:
Hi, There is a a correction in the question. Is there any command to find out the list of schedules running sorted based on the time in ASCENDING ORDER (or) DESCENDING ORDER?
I think the approach will be apparent in realizing that it is not Schedules that you see running in your TSM server, but the (admin) Processes and (client) Sessions initiated by administrative and client schedules. So, do a Select on the SESSIONS or PROCESSES table, sorting on START_TIME, where the SQL sort clause is ORDER BY, with a qualifier of ASC or DESC for ascending or descending, as in "ORDER BY START_TIME DESC". Richard Sims
