Delete jobs from project .
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 106
- Joined: Wed Oct 04, 2006 5:21 am
Delete jobs from project .
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.
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.
-
- Participant
- Posts: 106
- Joined: Wed Oct 04, 2006 5:21 am
-
- Participant
- Posts: 62
- Joined: Sat Mar 07, 2009 4:59 am
- Location: Chicago
- Contact:
Use Administrator
: 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 administratorthumati.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
Suresh Reddy
ETL Developer
Research Operations
"its important to know in which direction we are moving rather than where we are"
ETL Developer
Research Operations
"its important to know in which direction we are moving rather than where we are"
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 106
- Joined: Wed Oct 04, 2006 5:21 am
-
- Participant
- Posts: 106
- Joined: Wed Oct 04, 2006 5:21 am
List and Delete commands not able to fetch the records from repository in DS admin client.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.