For the admin schedules try:
select schedule_name,active from admin_schedules
regards,
Alexander
> Hi ,
>
> IS there a single command I can use to query the schedule and find the
> schedules that are not active.
>
> I did
>
> q sched type=admin f=d
>
> but I just want to see the name of the schedule and active?=yes/ no
>
> is it possible ? I'm sure it is and I believe some SQL statement can do it -
> wondering if anyone is having handy statement...?
>
> with regards,
>
> CAUTION - This message may contain privileged and confidential information intended
>only for the use of the addressee named above. If you are not the intended recipient
>of this message you are hereby notified that any use, dissemination, distribution or
>reproduction of this message is prohibited. If you have received this message in
>error please notify AMCOR immediately. Any views expressed in this message are those
>of the individual sender and may not necessarily reflect the views of AMCOR.
---
Alexander Verkooijen([EMAIL PROTECTED])
Senior Systems Programmer
SARA High Performance Computing
