regarding sequencer

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
Saama
Premium Member
Premium Member
Posts: 83
Joined: Wed Nov 22, 2006 6:42 pm
Location: Pune
Contact:

regarding sequencer

Post by Saama »

hi,

jobactivity----->jobactivity----->executecommand activity.

in the execute command tab.

command- net send my computer name
parameters- all jobs are successfully completed.
iam getting the error message.

SEQEXECUTECOMMAND..JobControl (@Job_Activity_2): Controller problem: Error calling DSAttachJob(drs15groupagg)
(DSOpenJob) Cannot open job drs15groupagg. - not a runnable job.
but when i run job individually i can run fine.
but when i want to run multiple jobs, this is happening.
i just want a message to be displayed-all jobs are successfully completed.
plz help me .

cheers;
saama
Saama
Premium Member
Premium Member
Posts: 83
Joined: Wed Nov 22, 2006 6:42 pm
Location: Pune
Contact:

Post by Saama »

hi,
sorry,now its running fine.
but i cant see the message displayed on my system.
it doesn't notify me that all jobs are successfully completed.
plz help me, how can i get a notification.

cheers;
saama
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

When you are running all the jobs in Sequence, the jobs might not be in runnable stare, either running or not compiled. But can you tell us, what are you trying to do in Executecomand activity?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY

Post by narasimha »

Couple of things -

In the Job Activity's Execution Action, select "Reset if required, then run".
That way the job is reset before running (To handle aborts in your previous runs).

You can check in the logs of the Job sequence, you will find the messages for the comletion of the job.
If you want to be notified by a mail, use a Notification Activity
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Go to the job properties window of your job sequence. On the General tab there are four check boxes. One of these is to log an event (in the job log of the job sequence) whenever a job is executed. Check that box and recompile the job sequence.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply