select statement similar to query client schedules
2003-03-19 07:14:55
Hello everyone!
I have a user that would like the output of the query the schedule event
records for the users to be sorted in alphebetical order by the node name
instead of the start time of the output. Is there a select statement that
can pull out the same info, but sort it by node name, actual start,
schedule name and status? Thanks!
Scheduled Start Actual Start Schedule Name Node Name
Status
-------------------- -------------------- ------------- -------------
---------
03/18/2003 20:00:00 03/18/2003 20:17:59 DAILY_INCR2 HMCH1124
Completed
03/18/2003 20:00:00 03/18/2003 20:06:19 DAILY_INCR2 HMCH1125
Completed
03/18/2003 20:00:00 03/18/2003 20:16:23 DAILY_INCR2 HMCH1129
Completed
Joni Moyer
Systems Programmer
joni.moyer AT highmark DOT com
(717)975-8338
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- select statement similar to query client schedules,
Joni Moyer <=
|
|
|