Page 1 of 1
Delete jobs from project .
Posted: Wed Mar 18, 2009 4:00 am
by thumati.praveen
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.
Posted: Wed Mar 18, 2009 4:41 am
by mahadev.v
In the designer, right click on the job name and select delete.
Posted: Wed Mar 18, 2009 4:45 am
by thumati.praveen
When i am trying to delete it is giving error message like (SOURCE OBJECT CANOT FOUND IN REPOSITORY )ANY body can help the same
Use Administrator
Posted: Wed Mar 18, 2009 5:09 am
by sureshreddy2009
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
Posted: Wed Mar 18, 2009 5:09 am
by tehavele
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 ?
Posted: Wed Mar 18, 2009 7:20 am
by keshav0307
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.
Posted: Thu Mar 19, 2009 1:48 am
by ghila
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
Posted: Thu Mar 19, 2009 1:50 am
by thumati.praveen
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.
Posted: Thu Mar 19, 2009 1:53 am
by thumati.praveen
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.
Posted: Fri Mar 20, 2009 1:18 am
by ghila
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