Automic Workload Automation

  • Private Community

  • 1.  Per SQL die letzte RunID auslesen / Read out the last RunID via SQL

    Posted Jan 17, 2019 06:33 AM

    Für statistische Auswertungen möchte ich gerne von inaktiven Objekten die letzte RunID per SQL auslesen. Bei der Suche mit dem Jobnamen möchte ich nur die letzte RunID als Rückgabewert haben.

     

    Habt ihr für mich das passende SQL Kommando?

     

    -------

     

    For statistical evaluations I would like to read from inactive objects the last RunID via SQL. When searching with the job name, I would like to have only the last RunID as the return value.

    Do you have the right SQL Statement for me?



  • 2.  Re: Per SQL die letzte RunID auslesen / Read out the last RunID via SQL

    Posted Jan 17, 2019 11:45 AM

    Hi

     

    Checkbox "inactive" or inactive as there are no statistics?

     

    cheers, Wolfgang



  • 3.  Re: Per SQL die letzte RunID auslesen / Read out the last RunID via SQL

    Posted Jan 18, 2019 01:14 AM

    The RunIDs that I want to read are from JOB, which are no longer visible in the Activities window.
    For example JOBS with an ENDED_OK status

     



  • 4.  Re: Per SQL die letzte RunID auslesen / Read out the last RunID via SQL

    Posted Jan 18, 2019 02:38 AM

    Hi

     

    there are several possibilities:

     

    * per click Statstics window (the easiest attempt)

    * per SQL

    * per Script

     

     

    if you use SQL there are several possibilities to obtain the last Run ID of the job...

    how do you want to use the last Run ID from these objects?

     

    cheers, Wolfgang