AutoSys Workload Automation

 View Only
  • 1.  Extract JIL from Database

    Posted Apr 09, 2021 04:57 AM
    Hi,

    I would like to extract the entire JIL of all my jobs from the DB BUT with a SQL request.
    I would like a backup every hour of the DB in CSV format with the status.
    the command autorep -J ALL -q is not suffisant and too long.
    Does someone could have this request please?

    Best regards


  • 2.  RE: Extract JIL from Database

    Posted Apr 10, 2021 06:04 AM
    UJO_JOBST view would have the most of the details you're after but not the entire JIL.


  • 3.  RE: Extract JIL from Database

    Posted Apr 14, 2021 06:14 PM
    you can give it a try to https://github.com/harshit740/JIL-To-Excel if you have python and openpyxl installed .


  • 4.  RE: Extract JIL from Database

    Posted Apr 14, 2021 06:15 PM
    You can try https://github.com/harshit740/JIL-To-Excel if you have python and Openpyxl Installed .


  • 5.  RE: Extract JIL from Database

    Posted Apr 14, 2021 06:15 PM
    you can give a try to (on github harshit740/JIL-To-Excel ) if you have python and Openpyxl installed.


  • 6.  RE: Extract JIL from Database

    Posted Apr 14, 2021 06:16 PM
    HI Bastiani,

    You can give a try to https://github.com/harshit740/JIL-To-Excel if you have python and openpyxl installed or you can get this installed.