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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers