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