Page 1 of 1

Problem of Misssing Jobs..

Posted: Thu Nov 09, 2006 6:07 am
by sibysjoseph
HI All,
This problem happened while i tried to kill a job. I went to the director and tried using the cleanup resource option and something strange happened.It seems like i am not able to find any jobs present in the director or designer(They are simply missing).How can i view the jobs back ?? Is it that the Jobs have vanished .?
I even tried Importing the jobs and it says that "Job already exist"..So if the job exists why am i not able to view th jobs ?
Kindly throw some light into this ..

Posted: Thu Nov 09, 2006 6:11 am
by WoMaWil
Try to reboot the Computer first only client and if that doesn't work also Server.

missing JObs

Posted: Thu Nov 09, 2006 6:16 am
by sibysjoseph
Hi WoMaWil,
Rebooting the server is out of option !!i have restarted the client and still the the problem persists ... :(

Posted: Thu Nov 09, 2006 6:29 am
by WoMaWil
go to the server and use on the Command line the dsjob statement for to see if you get there job details.

Posted: Thu Nov 09, 2006 6:40 am
by trobinson
You've corrupted or otherwise lost the index to the jobs. I assume you can't see them in Designer under the jobs category? Can you go to File on the main menu in Designer and open a job from the list? If so, then make sure no one is logged onto the DataStage server (No active ports except dsrpc LISTEN) and rebuild the Repository Indices (DS.TOOLS Option 2). All the jobs should re-appear.

Posted: Thu Nov 09, 2006 6:53 am
by sibysjoseph
hi trobinson,
As u said i am not able to see any jobs under the Jobs catogory.Again in the File option i don't see any jobs under existing tab,but i am able to open few jobs which are under the recents tab..

Posted: Thu Nov 09, 2006 7:05 am
by WoMaWil
hi joseph,

before you do anything to the index you should perhaps invest into investigation and get more simple solutions. If it is an other reason you may do more harm to DataStage than you need to.

Posted: Thu Nov 09, 2006 7:29 am
by DSguru2B
Also consider doing a backup, project wide backup, before you attempt anything.

Posted: Thu Nov 09, 2006 8:54 am
by ray.wurlod
Search the forum for the DS.REINDEX command.