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        (alexander AT sara DOT nl)
Alexander Verkooijen        (alexander AT sara DOT nl)
Senior Systems Programmer
SARA High Performance Computing