Job Does Not Exist
Posted: Tue Nov 25, 2008 7:40 am
Hello All,
I am facing a problem in deleting a job in Datastage Release 8.0.1.
I tried deleting the job through DataStage designer, it did not work. It was showing some RT_CONFIG5 error.
I deleted the job from DataStage Administrator using command:
"DELETE DS_JOBS JOBNAME"
The output of this command was 1 Records deleted.
But, still I can see that job in the Datastage Designer. I logged out and logged in again, NO LUCK. The weird part is , I cannot see the job present in the DataStage Director.
The job is not even getting renamed/deleted. To cross check I again fired query on UVSH
"SELECT * FROM DS_JOBS WHERE NAME=JOBNAME"
It returned NO ROWS. That means job is deleted from the engine.
Atlast, I tried to import the same job again in the project. The import error is "No Object found to Import."
When I import the same dsx file of the job in some other project then all goes fine.
Can anyone help me get out of this issue.?
Note: The job is exported from a Datastage Release 7.5 and imported to Datastage Release 8.0.1.
Thanks,
Amit
I am facing a problem in deleting a job in Datastage Release 8.0.1.
I tried deleting the job through DataStage designer, it did not work. It was showing some RT_CONFIG5 error.
I deleted the job from DataStage Administrator using command:
"DELETE DS_JOBS JOBNAME"
The output of this command was 1 Records deleted.
But, still I can see that job in the Datastage Designer. I logged out and logged in again, NO LUCK. The weird part is , I cannot see the job present in the DataStage Director.
The job is not even getting renamed/deleted. To cross check I again fired query on UVSH
"SELECT * FROM DS_JOBS WHERE NAME=JOBNAME"
It returned NO ROWS. That means job is deleted from the engine.
Atlast, I tried to import the same job again in the project. The import error is "No Object found to Import."
When I import the same dsx file of the job in some other project then all goes fine.
Can anyone help me get out of this issue.?
Note: The job is exported from a Datastage Release 7.5 and imported to Datastage Release 8.0.1.
Thanks,
Amit