Table Names

[Casey McKinney]

I have a developer creating a webpage that will provide synopsis type data from some of our batches.  He'd like to include job start time, end time, and duration.  Does anyone know the table names where this data can be queried? 

I opened a case but was told  "Normally we do not provide data external to our application as it becomes very confusing to interpretation and we do not have any ERD published for our schema."

Thanks in advance!

[Venkateshwar Goud Badrigari]

Hi Casey,

Always use a Web Service to retrieve the information you are looking for instead of directly querying the database.

Example: You can use GET method with job-run-info entry point to get the data.

https://<SERVER_NAME>:9443/AEWS/job-run-info/<job_name>?verbose=1

You will get output as shown below in XML format.  Highlighted avgRunTime and next start time - queuedTime (for STARTJOB type=107) below.

{
  "jobRun": [
    {
      "avgRunTime": "0",
      "runEndTime": "2025-09-15T11:25:44+0000",
      "exitCode": "0",
      "events": {
        "event": [
          {
            "alarm": "0",
            "evtNum": "123462",
            "type": "101",
            "processedTime": "2025-09-15T11:25:44+0000",
            "queuedTime": "2025-09-15T11:25:44+0000",
            "status": "1",
            "strStatus": "RUNNING",
            "ntry": "1"
          },
          {
            "alarm": "0",
            "evtNum": "123463",
            "type": "101",
            "processedTime": "2025-09-15T11:25:45+0000",
            "queuedTime": "2025-09-15T11:25:44+0000",
            "status": "4",
            "strStatus": "SUCCESS",
            "ntry": "1"
          },
          {
            "alarm": "0",
            "evtNum": "123465",
            "type": "107",
            "queuedTime": "2025-09-15T11:30:00+0000",
            "status": "0",
            "strStatus": "ACTIVATED",
            "text": "Event was scheduled based on job definition.",
            "ntry": "0"
          }
        ]
      },
      "name": "box_on_ice_test",
      "ntry": "1",
      "runNum": "18756",
      "self": {
        "@href": "https://XXXXXXX:9443/AEWS/job-run-info/box_on_ice_test?runnum=18756",
        "@rel": "self"
      },
      "runStartTime": "2025-09-15T11:25:44+0000",
      "status": "4",
      "strStatus": "SUCCESS"
    }
  ],
  "self": {
    "@href": "https://XXXXXXX:9443/AEWS/job-run-info/box_on_ice_test?verbose=1",
    "@rel": "self"
  }
}

Regards,

Venkat.

[Chandrasekaran Venkataraman]

We use iXp and iDash reports for this and migrating them to AAI slowly. AutoSys Web Services is convenient to plug it into your CICD pipelines but the challenge we have to convert the UTC/GMT time to our local timezone which could be tricky with DST shifts.

[John Hiett]

Hi Casey,

Have you considered taking a look at Automation Analytics & Intelligence (AAI) for your AutoSys reporting needs? A lot of our customers are moving their reporting and analytics needs to AAI, avoiding the need to build and maintain their own in-house solutions.

AAI has out-of-the-box insights that can show the job run details and durations you seek plus much, much more. My recommendation would be to take a look!

Kind regards,
Jon