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.
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
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
OR CJ.COMMAND LIKE 'sleep%'
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?