Re: q sched

2002-07-11 Thread Alexander Verkooyen

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



Re: q sched

2002-07-11 Thread Raghu Srinivas

Hi
 try this

select schedule_name,active from admin_schedules

bye
raghu



q sched

2002-07-10 Thread Ruksana Siddiqui

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.