Not compiled Status

Lotus26 · Post by **Lotus26** » Fri Mar 14, 2008 3:30 pm

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.

ray.wurlod · Post by **ray.wurlod** » Fri Mar 14, 2008 5:26 pm

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

kcbland · Post by **kcbland** » Fri Mar 14, 2008 5:49 pm

How are you generating your report? dsjob?

chulett · Post by **chulett** » Fri Mar 14, 2008 6:45 pm

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

ray.wurlod · Post by **ray.wurlod** » Fri Mar 14, 2008 7:39 pm

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

Lotus26 · Post by **Lotus26** » Sat Mar 15, 2008 9:40 pm

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?

ray.wurlod · Post by **ray.wurlod** » Sat Mar 15, 2008 10:35 pm

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.