Job Failure asap

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
vardhan354
Participant
Posts: 76
Joined: Wed Jan 25, 2006 6:42 pm

Job Failure asap

Post by vardhan354 »

Hi Folks,

I'm trying to run a master sequencer in a testing environment.The job runs for every 15 min.Whenever I run this job,I'm getting the following message.
" (fatal error from DSRunJob): Job control fatal error (-2)
(DSRunJob) Job jsCTdataTrnCTtoI is not in a runnable state) "

Could any one suggest me what could be the error......and how it can be overcome.

Thanks,

V.G
ETL
kris007
Charter Member
Charter Member
Posts: 1102
Joined: Tue Jan 24, 2006 5:38 pm
Location: Riverside, RI

Post by kris007 »

The error message suggests that the Job is not in a runnable state..which could be due to one of these reasons

1. Job is not in a compiled state.
2.Job could be in aborted state and you have set execution action in the JobActivity for this Job in the Job sequence to "Run". Change it to "Reset if Required and run."
3. The Job could be already in a running state. Since you have mentioned that this job is scheduled to run every fifteen minutes, may be it has not completed to finish its previous run before it is asked to run again. Hope that makes sense.

IHTH
Kris

Where's the "Any" key?-Homer Simpson
Post Reply