Workload Automation

Expand all | Collapse all

Autosys questions

Jump to Best Answer
  • 1.  Autosys questions

    Posted 04-08-2016 07:53 PM

    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



  • 2.  Re: Autosys questions
    Best Answer

    Posted 04-10-2016 03:42 AM

    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



  • 3.  Re: Autosys questions

    Posted 04-10-2016 08:20 AM

    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?