DSXchange

you can suppress it


/opt/app/dstage/DataStage752/Ascential/DataStage/DSEngine/bin/dsjob -server servname-user unam -password pwd -jobinfo $job_name PRJDEV | grep FAILED>/dev/null | grep -v "Status code = "

I am running the same code on my system.
its working fine here.

Hey Pandeesh,


Sorry my bad.

What you are doing in the script is correct.
What is going wrong when you run it?

So you want only the job name in the file right?

$? just says that the previous command was executed sucessfully or not.

It will alwas give 0 for your command because the command was executed sucessfully.

Can you please let me know why you are using the if condition.
based on what you want you might have to handle it differently.

try vertical pivot.

serach the forum you will get it

ya sorry my bad.

you can do this dataset ----- transformer--------seqfile in a transformer If [condition 1] Then "echo ":inputlink.col1: inputlink.col2:inputlink.col3...:">/directorey/file1.txt" else If[ condition 2] Then "echo ":inputlink.col1: inputlink.col2:inputlink.col3...:">/...

Hi,

You can create a wrapper stage

having this tr "\n" "abc" and pass all the column through the wrapper.

Regards,
Samyam

Thanks a lot craig.

Hi, I have modified the sequence. a sequencer in between with any and triggers OK conditional and the other trigger otherwise. Now I ran it with "automatically handle activities that fail " checked. same issue. and yes i am using jobstatus. so changing it to -wait instead of -jobstatus wil...

Hi Craig, I tried what you said. unchecked "automatically handle activities that fail " Then did a fresh run. Execute command worked fine the next activity failed. Restarted the sequence It did not skip the Execute Command but it ran the dsjob command in the execute command activity. Or i ...

Hi,

Everything checked

add checkpoint
log warning after activities that finish with not OK
aoutomaticaly handle activities that fail
log report messages after each job run

But there is no unhandles exception

I am not getting any error.
But i do not want the execcmd activity to run again thats all.


What should i search for.
sequence restartablilty?

Hi, with the exec command activity the job runs fine. but there is one issue. execcmd---------jobactivity1-------------jobactivity2 now in the first run the execcmd runs fine, but the jobactivity1 fails. then when we restart the job from director. it shoud start from jobactivity1. but actually when ...