DSXchange

That 'After Job' ExecSH executes a shell command, meaning either O/S command or a script. You need a script to connect to your db via the command line utility they provide and then issue the four proc calls you noted.

The initial release only supported Oracle, so you won't be able to use the actual Stored Procedure stage for this, it seems.

So... you're trying to identify jobs that have not run in the last six months? :? That information won't be in DS_JOBS but rather in each individual job's RT_STATUSnnn hashed file, I believe. And it is not something that is openly documented but certain people here probably know exactly where that w...

You could script this to run 'After Job' or create a separate job and use a Sequence job to run the two one after the other. Or you try executing them in the After SQL tab of the last stage.

Great! Thanks... will check this out as soon as practical and let you know.

:D

I'm curious if anyone has seen anything like this. First off, we have 8.1 running on Linux, no clue if this applies as well to any flavor of 8.0. There seems to be a magic limit of 3 on client connections and it doesn't appear to be tied to any licensing limits as I am the only person connected to t...

Andy, any chance of a link to this 'rollup patch'?

Please shed some light on your job design.

Go back and edit your second post, wrapping the code in

I don't see how that would help, you still have to declare a delimiter, and space would still get you the issue noted in the first post. Or am I missing something? I think you'll need to do some intelligent parsing - find the number of fields in the string by counting the delimiters. Pull off the la...

Nice, thanks for posting that Andy.

No, just being a smart alec, the 'crazy thought' was that you might actually just search for the answer rather than ask someone to type it up one more time.

That or use the CAPITALS transform which does the exact same thing but is a little more 'self documenting'.

Please post the syntax you used for your second attempt.

You may want to read this thread where you seem to have the same requirements as srai.