DSXchange

How to get running jobs list for a project. Is there a direct way. Or should I list all the jobs name from the project and check the status of each job in loop.

What is the quickest way to get this list, considering the response time doing this in loop would take more time?

Basically, I am trying to find out whether the Datastage server is idle meaning, no jobs are running currently considering all the projects in that server...

Thanks

Unless you need the precise status of every job, I wouldn't bother to loop thru them all. Sounds like a quick "ps -ef |grep phantom| grep -v grep" could get you what you need.

Checking in director manually , Using dsjob -jobstatus or ps -aef | grep phamtom | grep -v grep | wc -l .

Use Director status view, disable display of Category and sort by status (click in the grid row header to sort). You can print this report, or print to file.

Director would be a manual process and switching projects manually would take time.

So I would prefer to use the ps unix command. But the question what I have for ps command is that, if the team has opened the jobs in designer, will this ps command bring those processes as well?

Thanks

No, you'd have to search for something else to find things like that. Since 'phantom' is a background process for a running job, that's all you'll find.

Thanks chulett.

I was just wondering whether the jobs opened in designer would also come as part of the ps phantom. If this does not bring the designer process, then I am happy.

Because, I am trying to find only the jobs that are running. Thanks for the help, I will check this.

Ramani wrote:Director would be a manual process and switching projects manually would take time.

So I would prefer to use the ps unix command. But the question what I have for ps command is that, if the team has opened the jobs in designer, will this ps command bring those processes as well?

Thanks

These are new requirements. The original question merely asked for the quickest way. Wanna race?

As per my understanding, only the server jobs run with the phantom process what i am not sure is will a grep on 'phantom' capture the running PX jobs?

Easy enough to check.

zulfi123786 wrote: will a grep on 'phantom' capture the running PX jobs?

Yes, It will capture the PX jobs as well.

I would just want to clarify on this that sometimes I have found phantom process on Unix server with parent process as root and job had completed long back. Sso, isn't it not displaying correct result.

Different issue, and I would question the fact that the job truly 'finished' if there are still processes associated with it.