topic QUERY CURRENT STEP in ArcGIS Workflow Manager Questions

QUERY CURRENT STEP

Ulises — Fri, 27 Aug 2010 04:01:22 GMT

Is there any way to query current steps in a job and who has it assigned??? I want to generate a report that show the user, job_id, current step, and dates. The idea is to allow managers to track daily progress (ex. who is not achieving the daily cuota). We have version 3.0.1.

Thanks

Re: QUERY CURRENT STEP

AndrewMcColgan — Fri, 27 Aug 2010 15:31:43 GMT

I'm using version 9.3.1, but was able to get what you are looking for using the attached job query.

-Andrew McColgan
Computer Software Specialist
Memphis Light, Gas, and Water

Re: QUERY CURRENT STEP

Ulises — Wed, 09 Feb 2011 17:59:18 GMT

Thanks Andrew...it works nicely. But is there a way to export the job history to a file? I'm trying to create a report outside of JTX...

Re: QUERY CURRENT STEP

BrianDemers — Thu, 10 Feb 2011 20:36:52 GMT

Hi,

Even at version 10, I don't know of an out-of-the-box way to export job history to a file. However, job history is stored in the "JTX_HISTORY" table so there may be some options...

If you'll be exporting the job history frequently and you're familiar with Python, you could write a Python script to extract the information from the JTX_HISTORY table for a given job and save it to a text file. From what you describe, that's probably the best immediate solution.

Alternatively -- admittedly, this probably isn't viable if these are daily reports -- you could use ArcCatalog to copy/export the JTX_HISTORY table to another format. For instance, export it to a .dbf file then open the .dbf in Microsoft Excel, or copy the table into a Personal Geodatabase then view the pGDB with Microsoft Access. From Excel or Access, you could presumably convert the data yet again.

One last idea: if/when you're able to upgrade to a newer release, you could look into setting up a Workflow Manager web application (downloadable from the resource center). Using ArcGIS Server and Workflow Manager Server, these apps make it possible to view job information over the web. (It sounds like this "track jobs without everyone installing Workflow Manager" may be what you're really looking to do?)

Good luck!

Brian D.