Checking User/Job status on Sequnce link

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
johnno
Participant
Posts: 50
Joined: Wed Mar 05, 2003 5:33 am

Checking User/Job status on Sequnce link

Post by johnno »

I have been experiencing some rather weird results when checking the user status and job status in custom triggers for a job activity within a sequence. The code I am using is:

CheckStationId.$UserStatus = 2 AND CheckStationId.$JobStatus <> 3

Although the UserStatus = 2 and the JobStatus = 0, the next job in the sequence does not run, the sequence in fact finishes at this point and says everything is OK.

Any suggestions?

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

Post by kduke »

The 2 will be =2 and <>3. Look at your logic again.
Mamu Kim
johnno
Participant
Posts: 50
Joined: Wed Mar 05, 2003 5:33 am

Post by johnno »

Thanks Kim,

Have got it working now - it only appeared not to be continuing with the sequence when it actually was. Have now put calls to dsloginfo to indicate when a certain routine was being run.

Cheers
John
Post Reply