Delete jobs from project .

thumati.praveen · 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 · Post by **mahadev.v** » Wed Mar 18, 2009 4:41 am

In the designer, right click on the job name and select delete.

thumati.praveen · 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 · 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

tehavele · 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 ?

keshav0307 · 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 · 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 · 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 · 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 · 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

DSXchange

Delete jobs from project .

Delete jobs from project .

Use Administrator