DSXchange

How about this?

ray.wurlod wrote:Why don't you specify in English what you want to achieve?

Please do that so we don't waste any more time going 'round and 'round with inappropriate solutions.

automatically handle activities that fail This one is the one that takes non-zero output from stages that return a value to mean 'failed' and why it runs again on a checkpoint restart. Try putting a Sequencer set to 'Any' between the Execute Command stage and the next one with two links between the...

The 8.0.x release was notoriously buggy, are you current on your fixpacks?

Do you see how "Ans" was being treated as a dynamic arrary in the code you first posted and then you removed that bit of magic from the second iteration of the code? Now you want to treat your vEventDetail in that same fashion so it inserts a new array element each time through the loop ra...

You attach using the job's name and the result of that attachment is the handle that you are storing in hJob. And job names are unique so there's no need for the folder / category.

Make sure you detach when you are done as well.

DSGetNewestLogId(hJob, DSJ.LOGANY) fetches all the entries in the log regardless of fatal,warning or information. Is there any other option available to fetch the fatal alone? Yes and a quick check of the documentation should clear that up for you. Hint: you told it you wanted DSJ.LOGANY - that's n...

There would typically be a message about an "unhandled exception" from the Execute Command stage, is that not there? Tell us which compiler options you have enabled in the Sequence job... enable checkpoints, etc.

Take a look at the error that was generated and then do an exact search here for it. That situation, the error and the resolution have been discussed here many many times.

Ah, that would have been good to mention in your first post as we would have known right away it was a grants issue. Without the mention, there's an assumption of... sameness... across attempts.

Bummer, guess I was thinking it had a structure like the Folder stage.

Did you try doing as I suggested?

OK... that was off the top of my head and I got the function name wrong. Was it really that hard to try and look up what I really meant? :? Switch it to DSGetLogEntry. Note that you'll need to include the use of DSGetNewestLogId as well from what I recall. Search for forums for examples of the synta...

Seems to me the Aggregator would work for this, group on the first column and take the max of all the others.

Call? Yes. Capture? No. As far as I know, you'd need to use the actual Stored Procedure stage for that functionality.

No. The implication, as you've already noted, is that the parameters are not in fact getting passed correctly. Make sure you use the External Parameter Helper to populate the parameters in the Job Activity stage and don't type them in by hand. If you did them by hand, suggest you redo them as noted ...