ADSM-L

Re: Commands to fins the schedules running -- sorted by time

2006-10-26 07:07:11
Subject: Re: Commands to fins the schedules running -- sorted by time
From: Richard Sims <rbs AT BU DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 26 Oct 2006 07:06:22 -0400
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

<Prev in Thread] Current Thread [Next in Thread>