srikanth.bachu
9th May 2008, 07:05
Currently we Have LN 6.1 in Linux box. can any one tell how to retrive the status of the JOb (Status: free,waiting, In Queue......) using AFS scripts

en@frrom
9th May 2008, 11:26
No need for AFS. Just query the table ttaad500 (field jsta)...

srikanth.bachu
12th May 2008, 06:42
Thnk you EN. u mean to say we need to build query like the below:
select t$jsta from tttaad500CMP where cjob='jobname';


and one more question is how to update the Status of the Job. if the Job Status is in Runtime we need to update it to free can you tell how to do it. using AFS script.

Thanks in Advance