Autosys questions

[Anon Anon]

Hi Team,

 

Could you please help me with following questions -

 

1) is there any wat we can rename autosys jobname? so that i update all downstream jobs dependency. if not what should be the easiest way.

2) How can I find empty boxes?

3) how can i find jobs calling sleep or /bin/true command.

 

 

Thanks

 

Regards

MB

[Chandru.Venkataraman]

Hi Manish,

 

It is not possible to rename a job in AutoSys; one has to delete and re-insert the job and then update all its successors with the new name.

 

The follow SQL query against the AutoSys database will give you list of empty boxes:

SELECT job_name FROM ujo_job

WHERE job_type='98'

AND IS_ACTIVE=1

AND IS_CURRVER=1 

AND joid NOT IN (SELECT DISTINCT box_joid FROM ujo_job WHERE IS_ACTIVE=1 AND IS_CURRVER=1)

 

CA iXp provides option to search jobs using command or machine or owner wildcards. If you have access to the AutoSys database the following SQL may help:

 

SELECT J.JOB_NAME, CJ.COMMAND

FROM UJO_JOB J, UJO_COMMAND_JOB CJ

WHERE CJ.JOID=J.JOID

AND CJ.COMMAND='/bin/true'

OR CJ.COMMAND LIKE 'sleep%'

 

Thanks,

Chandru

[Anon Anon]

Thanks Chandru for your response. I am afraid I don't have access to autosys database access. not sure if I will be able to get access. so I presume this is not possible from commands?