Sharing job

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
iamrajy
Participant
Posts: 20
Joined: Mon Apr 26, 2004 10:38 am

Sharing job

Post by iamrajy »

I am trying to share jobs in various sequences. Even thought the sequences are not running parallel, I am getting this error message. I am running sequence through "Job Control".

SequenceNodeAttributeMap..JobControl (@OciNewAttributeValueInsert): Controller problem: Error calling DSRunJob(OciNewAttributeValueInsert), code=-2
[Job is not in the right state (compiled and not running)]


SequenceNodeAttributeMap..JobControl (@InternalAttributeValueHash): Controller problem: Error calling DSRunJob(LkUpInternalAttributeValueHash), code=-2
[Job is not in the right state (compiled and not running)]

Can somebody tell me what I am doing wrong.
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

If this is a server job then make it have multiple instances.
Mamu Kim
iamrajy
Participant
Posts: 20
Joined: Mon Apr 26, 2004 10:38 am

Post by iamrajy »

Let say I choose a "multiple Instance" option (Job is refreshing a hash). If Job1 and job2 are refreshing a hash simultaneously and then job3 want to use the "hash" which got refreshed by job1 and Job2. So in this situation which values will be visible ( Rows refreshed from job1 or job2 )

-Thanks
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

I would create a parameter which has a one to one relationship to the instance of the job. Next add this to the hash file name so each job has a separate hash file.
Mamu Kim
Post Reply