DSXchange

Ah... the dreaded SCOTT schema. Someone is practicing, me thinks.

ray.wurlod wrote:I don't know the answer to your second question, but believe it is yes.

Really? Yes, the answer is yes. A Charter Member would be one of the first 500 Premium Members to sign up and for which you received a 50% discount on the cost.

ray.wurlod also wrote:Roy?

Exactly. One of them between the EC stage and the next JA stage. And make sure your script passes back a non-zero exit status if something goes wrong in it, otherwise your next job will always think it ran ok and things will not stop.

Hmm... UNIX server, DS 7.5.1A - question marks. And it specifically complained about the colons. Still, the actual errors were not posted - they were paraphrased instead - so who knows.

I'll step away and let you guys 'work it out'.

Either one can work, it's your call. Me, I'd prefer it be a discrete step in the Sequence job, each Job Activity stage would have a trailing Execute Command stage.

Yes.

Ah, ok. You can't do this before sql so put that from your mind. Your two options are before job or before stage and I'd suggest the former.

An 'unconditional' trigger between B and C just says to run C regardless of what happens to B. Nothing more, nothing less. That's the only point I was making here.

my query looks like this update <tbl> set fld1 = :1, fld2 =:2, fld3 =:3 where fld4 := 4 and fld3 = <constant value> So... what you are doing doesn't actually "look like this". It never helps to post "generic" examples as they make it too easy for people trying to help to be led astray. Not work = g...

ensure that you have exactly 4 colums defined in the stage and that the 4th one is the only one marked as a Key. 7 columns would require 7 parameter markers to bind them. Any field used in the 'where' clause must be marked as a Key field. Unless we're talking ODBC here, anything else will *not* work.

Suggest you look into DSGetLogEntry rather than DSGetLogSummary.

shrinivas wrote:I have customed the condtion to check the failed status of job B.

All that should need is an Unconditional trigger.

What the heck does sqlplus or your database have to do with needing to ftp something?

Ok, fair enough. Post your actual error then. And ensure that you have exactly 4 colums defined in the stage and that the 4th one is the only one marked as a Key.

Have you... contacted your Support provider?