Job Name from RT_CONFIGXXX

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

Post Reply
russ356
Charter Member
Charter Member
Posts: 38
Joined: Tue Jun 07, 2005 6:58 am

Job Name from RT_CONFIGXXX

Post by russ356 »

I am doing some cleanup on our test box and when I open the project in Director I get the error.

Cannot open executable job file RT_CONFIG43

My question is how can I get the job name for RT_CONFIG43. I have a process that I will do to delete the job but I don't know what the job name is, so where can I look to get this?

Thanks

Russ
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Code: Select all

SELECT NAME FROM DS_JOBS WHERE JOBNO = '43';
Execute from command window in Administrator client.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
russ356
Charter Member
Charter Member
Posts: 38
Joined: Tue Jun 07, 2005 6:58 am

Post by russ356 »

Thanks, I knew it was something easy.
bcarlson
Premium Member
Premium Member
Posts: 772
Joined: Fri Oct 01, 2004 3:06 pm
Location: Minnesota

Post by bcarlson »

How do you delete the job when you get that kind of error? We have gotten this before, too. I would be interested to see how you do this.

Thanks!

Brad.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Usually the job is visible in the graphical tools and you can delete it from there. If it cannot be seen or deleted, then the TCL command "DS.CHECKER" will probably be able to do so. Failing all that, I would go in and manually delete the hashed files associated with that job. I'd also check the project for other problems.
Post Reply