Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
thumati.praveen
Participant
Posts: 106 Joined: Wed Oct 04, 2006 5:21 am
Post
by thumati.praveen » Wed Mar 18, 2009 4:00 am
Hi,
Can any suggest the way to delete the jobs from project?
Jobs designs are avilable in designer but not in Adminnistrator and director clients.
Thanks,
Praveen.
mahadev.v
Participant
Posts: 111 Joined: Tue May 06, 2008 5:29 am
Location: Bangalore
Post
by mahadev.v » Wed Mar 18, 2009 4:41 am
In the designer, right click on the job name and select delete.
"given enough eyeballs, all bugs are shallow" - Eric S. Raymond
thumati.praveen
Participant
Posts: 106 Joined: Wed Oct 04, 2006 5:21 am
Post
by thumati.praveen » Wed Mar 18, 2009 4:45 am
When i am trying to delete it is giving error message like (SOURCE OBJECT CANOT FOUND IN REPOSITORY )ANY body can help the same
sureshreddy2009
Participant
Posts: 62 Joined: Sat Mar 07, 2009 4:59 am
Location: Chicago
Contact:
Post
by sureshreddy2009 » Wed Mar 18, 2009 5:09 am
thumati.praveen wrote: When i am trying to delete it is giving error message like (SOURCE OBJECT CANOT FOUND IN REPOSITORY )ANY body can help the same
:
Go to Datastage Administrator and in projects tab we have one option ClenUp click that option and it will deletes all the contents of the repository, but the project wont deleted , this will helps only u want to clean the whole repository otherwise if you want to delete the jobs only, you want to delete in the designer or director but according to you the job designs are there and job is not present in datastage director so it's better to clean up total repository in administrator
Suresh Reddy
ETL Developer
Research Operations
"its important to know in which direction we are moving rather than where we are"
tehavele
Premium Member
Posts: 79 Joined: Wed Nov 12, 2008 5:41 am
Location: Melbourne
Post
by tehavele » Wed Mar 18, 2009 5:09 am
thumati.praveen wrote: When i am trying to delete it is giving error message like (SOURCE OBJECT CANOT FOUND IN REPOSITORY )ANY body can help the same
Are you able to open that job in the designer ?
Tejas
keshav0307
Premium Member
Posts: 783 Joined: Mon Jan 16, 2006 10:17 pm
Location: Sydney, Australia
Post
by keshav0307 » Wed Mar 18, 2009 7:20 am
some object for this job is corrupted, so you need to delete it from repository tables.
1. Get the Job id
2. delete from ds_jobs where NAME =<job name>
3. delete from JOB_OBJECTS WHERE NAME =<job name>
just check the column names, not sure its NAME or JOBNAME.
ghila
Premium Member
Posts: 41 Joined: Mon Mar 15, 2004 2:37 pm
Location: France
Post
by ghila » Thu Mar 19, 2009 1:48 am
thumati.praveen wrote: When i am trying to delete it is giving error message like (SOURCE OBJECT CANOT FOUND IN REPOSITORY )ANY body can help the same
Ask the IBM tech support. They will provide you a script that will let you delete job in the xmeta repository as well.
Regards
Daniel
thumati.praveen
Participant
Posts: 106 Joined: Wed Oct 04, 2006 5:21 am
Post
by thumati.praveen » Thu Mar 19, 2009 1:50 am
tehavele wrote: thumati.praveen wrote: When i am trying to delete it is giving error message like (SOURCE OBJECT CANOT FOUND IN REPOSITORY )ANY body can help the same
Are you able to open that job in the designer ?
Yes I can ,but the probelm is I can not compile/run the job.
thumati.praveen
Participant
Posts: 106 Joined: Wed Oct 04, 2006 5:21 am
Post
by thumati.praveen » Thu Mar 19, 2009 1:53 am
keshav0307 wrote: some object for this job is corrupted, so you need to delete it from repository tables.
1. Get the Job id
2. delete from ds_jobs where NAME =<job name>
3. delete from JOB_OBJECTS WHERE NAME =<job name>
just check the column names, not sure its NAME or JOBNAME.
List and Delete commands not able to fetch the records from repository in DS admin client.
ghila
Premium Member
Posts: 41 Joined: Mon Mar 15, 2004 2:37 pm
Location: France
Post
by ghila » Fri Mar 20, 2009 1:18 am
In Information Server 8.x you need to delete records in the xmeta repository ( located in DSJobDef and DSItem ). Deleting in Universe is not enough.
So, please ask IBM tech support the DStageWrapper script and the way to use it.
Regards
Daniel