Pending Workflow job monitoring!!

How can I get details about the Pending workflow jobs which are displayed in the workflow section of Teamsite.I mean is there any files or xmls where the details are logged in.I want to automate the END JOB feature on pending workflows,thats why I require this information.

Find more posts tagged with

Comments

nagendra

iwgetwfobj, iwqueryjobs, iwquerytasks and iwrmjob CLTs should be useful.

Icebreaker

Hi Amandal,

You can create a script that lists all the pending workflows to a file.

And another script that takes the above output and end each workflow.

Regards,

amandal

Thanks both of you !!But is there any CLT which will list all the pending workflow jobs,since I am new to the application thats why I am asking this.

Adam Stoller

Thanks both of you !!But is there any CLT which will list all the pending workflow jobs,since I am new to the application thats why I am asking this.

Already answered:

iwgetwfobj, iwqueryjobs, iwquerytasks and iwrmjob CLTs should be useful.

Now you have to read the manuals and play with the CLTs in order to figure out how to do what you want.

amandal

I run the job query like
./iwqueryjobs < query.xml
Where query.xml is like

It lists all the active jobs in the system.
But my requirement is to get the Initiation date of the job so that I can check the status of the jobs which are pending since long.

DO I need to write the DTD or is there any CLT which returns details about the active jobs.

Is there any help docs in creating DTD.

Thanks in advance for all the help.

Adam Stoller

I run the job query like
./iwqueryjobs < query.xml
Where query.xml is like
<wfquery>
<and>
<active/>
</and>
</wfquery>

It lists all the active jobs in the system.
But my requirement is to get the Initiation date of the job so that I can check the status of the jobs which are pending since long.

DO I need to write the DTD or is there any CLT which returns details about the active jobs.

Is there any help docs in creating DTD.

Thanks in advance for all the help.

The query above will list out the job-id's of all active jobs in the system - you would then have to pipe this information through some other program to retrieve the details of those jobs - e.g.: iwgetwfobj - from which you could then extract the activation time, which will be in the format of seconds-since-epoch which you could then process in order to turn it into a more understandable format.

Alternatively - you could write some Perl code using TeamSite::WFsystem, TeamSite::WFworkflow and/or TeamSite::WFtask - and perform all these operations - this would then be creating your own CLT to do specifically what you want.

If you do not understand how to write such code - consider hiring someone who does - or hope that someone here (perhaps even I) decides to volunteer such code for free. Personally, I'd rather you try writing the code yourself and if it doesn't work - post it - and I'd be much more likely to correct code you've written than write it for you from scratch (since that's how I earn my living)

Also - in the future when making posts here - remember to include information about what version of TeamSite you are using, and on what platform - as that kind of information may affect the validity of the responses you get back.

Icebreaker

Hi Amandal,

Take a look of the attached file. You might have to put in your module for logs.

The attached file gives you a list of active workflow with workflow_id, workflow_name, workflow_owner, workflow_creator, activation_time, active_task

Hope this helps....

Regards,