Listing jobs within workflows

[IanFindon611036]

As a business we currently operate a 4 week period calendar - However, we are now looking to move to a monthly calendar ... The support teams working on this want a list of our workflows/jobs which use our specific periodic calendars.

Is there an easy way to accomplish this with AE ?

If not, I can manually identify the workflows - so another question ... I can export the details into an xml file format - Is there another way of getting the details to a more readable format - .csv .txt etc. or indeed can one save when using the print option as this shows all the details I am required to give to our support teams working on the calendar change

[Simone Martineschen]

Hi Ian,
From what I understood you want to generate a list of the tasks that are inside your workflows, correct? If so, I tried a lot of things in the past using AE only. They are:

- generating XML files and with prep_process_file on these xml files, generate a csv files of the tags content that I needed
- running some queries on the database to extract the info from the workflows
- printing the workflows to a pdf file
- outside AE, using PrintView to extract the design of the workflows. PrintView enables the use of scripts to print so it's more useful that the regular print function,

Hope this helps.

[IanFindon611036]

@Simone Martineschen - Thanks Simone - I'll check these out with our DBA's

[Simone Martineschen]

IanFindon611036 , there are really cool examples of DB queries to extract child objects from JOBPs on PhilippElmer 's blog. Check out these links: http://www.automicblog.com/automicblog/sql-children-and-parents-of-processflows-and-schedules/ and http://www.automicblog.com/automicblog/recursive-workflow-export/

[Anon Anon]

For the list of objects that use a calendar object you can use the Search dialog and choose the Search for: Usage of objects.

I would suggest that you review Philipp Elmer's great AutomicBlog.com site. There are many useful examples of SQL including this one one that might be a basis for what you need: SQL: Children and Parents of ProcessFlows and Schedules.

We often export a number of work flows and process the XML with an in-house written utility type program to make a nicely formatted report or csv for further processing.

[Uday Giri Vytla]

HI Anon Anon,

I couldn't open the links you provided.
Can you help me to provide a sql query to extract jobs running in a workflow.

Regards,
Uday Vytla

[Carsten Schmitz]

Hi.

I couldn't open the links you provided.

Me neither. But then, you necro'ed a thread from Feb 2016!

Here's archive.org's version of the link, which is still available to this day:

https://web.archive.org/web/20160424060151/http://www.automicblog.com/automicblog/sql-children-and-parents-of-processflows-and-schedules/

Hth,