Issue with Job activity stages in sequencer

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sravanthi
Participant
Posts: 83
Joined: Fri Jun 02, 2006 5:37 am

Issue with Job activity stages in sequencer

Post by sravanthi »

Hi,

I have a sequencer which calls couple of parallel jobs along with execute command stages.
The problem is the job is getting finished in couple of minutes but the sequencer is taking more than 10-30 min to execute next stage. I have a script in after job routine..thought problem with the script and changed the job and removed after job routine and used execute command stage after job activity in sequencer .

Even now the sequencer is taking longer time to execute next stage.Job will be finished though.

The sequencer job log:

Occurred: 2:17:28 PM On date: 3/2/2009 Type: Info
Event: sequencer..JobControl (@Job_pxJob): Checkpointed run of job 'pxJob'
Occurred: 2:41:06 PM On date: 3/2/2009 Type: Info
Event: sequencer..JobControl (@Execute_Command_298): Checkpointed execution of command 'ksh'

Please advice!
girija
Participant
Posts: 89
Joined: Fri Mar 24, 2006 1:51 pm
Location: Hartford

Post by girija »

Create two sequence one contain only Job and another contain your script.
Run them separately and let see.
sravanthi
Participant
Posts: 83
Joined: Fri Jun 02, 2006 5:37 am

Post by sravanthi »

Thanks!

I will give a try.
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

How much time that script takes to execute and what is there in the script?
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
sravanthi
Participant
Posts: 83
Joined: Fri Jun 02, 2006 5:37 am

Post by sravanthi »

To start execution of the script sequencer is taking nearly 20 min after completing previous stage.

The script is adding a trailer at the end of the file created by the job. The execution of the script is completed in 2 min .But the time taken to start next stage is again nearly 20 min by sequencer.
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Maybe you have a sleep in the script.

Check the Finished and Starting times for jobs.

Also can you log messages from script to see when it really finishes.

How many people and working / running ds jobs?
Post Reply