DSXchange

Hi

I am trying to generate a report for all my datastage jobs . But in case some of the jobs were not compiled then it is giving an error message .


ERROR: Failed to open job

How to capture the status of those jobs , so that I can avoid to check those jobs from my report.

Thanks in advance.

Open Director. Disable Show Categories in the View menu. Sort by Status. Find those Not compiled. They will be in a single group.

How are you generating your report? dsjob?

That's the question - and the answer will drive your solution.

Another way. Open the Multi Job Compile tool and check the "Select only uncompiled jobs" check box.

Hi

Thanks for all your responses .

But I want to find out the status through command line and I want to avoid the uncompiled jobs by capturing the status of the uncompiled jobs also through command line .

So can you help me how can I achieve this?

I don't believe it can be done, other than invoking DataStage/SQL from the command line. You don't want to go there - it involves querying a separate status table for every job.