DSXchange

Hi,

I have a job Dimclt in one of the project Project1 and I'm trying to import the job in to Project2, it is saying that the job is already exists and I'm not able to find the job using advanced quick search.

When I typed below command in Administrator command line

SELECT NAME FMT '30L', CATEGORY FMT '46L' FROM DS_JOBS WHERE NAME NOT LIKE '\\%' AND JOBTYPE = '0';


I got the below list

JobName----------- ----Category

DimClt
DimTyp \Jobs\CLIENT

So from above output, I'm not able to find the Category where it is located. I want to find the job and delete that job before import.

Thanks,
Somaraju

Let us know what output you get.

Hi Ray,

I got the below message

LIST.ITEM DS_JOBS ''DimClt'' 15:49:32 10-28-10 PAGE 1

DimClt

001 NR0
005 14

Thanks,
Somaraju

Keep in mind the fact that it may not actually be in any category but could be out at the 'root' level. I've 'lost' more than one job out there over the years.

Hi Chulett

I don't see a job in project level or in any category from Designer client. Can you tell me what is this root level mean in Datastage designer. Where do I need to look for the root path.



Thanks,
Soma

Root = Project level, so if you don't see it when you click on the project name rather than a category then that's not the issue.

Hi,

Can some one tell me how to delete the job that is in root directory



Thanks,
Somaraju

Hi,

Can some one tell me how to delete the job that I cannot see any where in the rerpository from Designer Client.



Thanks,
Somaraju

Sounds like your XMETA repository is out of sync with the local/legacy/'Universe' repository. You'd need to involve your official support provider for help getting that cleaned up and bakc in sync.

Ray: Please note that I put 'Universe' in quotes just for you.