corrected the job
Moderators: chulett, rschirm, roy
corrected the job
Hi,
My job is corrected. I am unable to rename and delete the job.
I went through below link. I followed same what they are telling. But It is not working for me.
viewtopic.php?t=113012
Please help me
My job is corrected. I am unable to rename and delete the job.
I went through below link. I followed same what they are telling. But It is not working for me.
viewtopic.php?t=113012
Please help me
I assume you mean "corrupted" here. And I feel like we came in the middle of a conversation.
Start over. Tells us what exactly it is you are experiencing and the error(s) you get. I know you posted a link (which is good) but it would be helpful to know what you tried from it and what "not working for me" means.
Start over. Tells us what exactly it is you are experiencing and the error(s) you get. I know you posted a link (which is good) but it would be helpful to know what you tried from it and what "not working for me" means.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 32
- Joined: Tue Dec 20, 2011 8:03 am
-
- Participant
- Posts: 32
- Joined: Tue Dec 20, 2011 8:03 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Your approach leaves may orphan records in DS_JOBOBJECTS (note, too, that it's a letter "O", not a zero, in the name). You are missing deleting every stage, every link and every annotation.
What you really need is
What you really need is
Code: Select all
DELETE FROM DS_JOBOBJECTS WHERE OBJIDNO = (SELECT JOBNO FROM DS_JOBS WHERE NAME = '<<Job name>>');
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Records that describe/record the properties of stages, of links, of containers, of annotations.
Get yourself a premium membership and you can read the complete solution in my previous post.
Get yourself a premium membership and you can read the complete solution in my previous post.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You're wrong. For starters the table name is DS_JOBOBJECTS. Secondly, the linkage between DS_JOBS and DS_JOBOBJECTS is through the job number, not the job name.
If you delete the job from Designer, all of the records from DS_JOBOBJECTS are removed. If you delete only the ROOT record from DS_JOBOBJECTS then you leave all the orphans I mentioned previously.
If you delete the job from Designer, all of the records from DS_JOBOBJECTS are removed. If you delete only the ROOT record from DS_JOBOBJECTS then you leave all the orphans I mentioned previously.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: