DSXchange

Don't recall if this is supported, but did you try your new derivation without the UserVariables stage, directly in the Start Loop?

Field(Execute_Command_0.$CommandOutput," ",1)

The closest you'll get to 'dynamic' (IMHO) is the Update Action of 'Load SQL from a file at run time'. Then the area where you would normally put your user-defined SQL holds the actual pathname of the file to load. Something to note, however, if you do that. While you can use job parameters for the ...

Depends on your definition of 'dynamic'. What are you trying to accomplish?

That will have to come later, I only have time for a quick wise-crack or two right now, can't really spare any serious think time.

Ah... the joys of ASCII Art!

Do they execute anything 'before job'?

A restarting Sequence starts at the Aborted step. If JobB aborted, it would have restarted from there. Aborting the Sequence after it completes successfully buys you nothing.

You can certainly 'select multiple jobs to move' - as long as they are all under the same Category, the normal Windows selection methods apply. You can't pick and choose across categories, however.

I love posts like this. Not.

You 'do the needful' first. Explain in words what you need to accomplish, don't assume everyone knows 'Informatica logic'. That way, anyone can help you.

Well... perhaps. Forget about them being 'column names' and try writing them as the first data record.

Use the UserVariables stage for dynamic values, ones that change from run to run. For this, simple Job Parameters will work fine. Unless, of course, they really need to be dynamic.

Typically a target SQL issue - I'll wager no indexes for an update and thus full table scans are being performed.

AmeyJoshi14 wrote:Do you still support your stand?

Absolutely. That's why it's called a stand. And I stand by my assertion.

Your list from the Help is as bare-bones as a Scheduler can get and still be called a Scheduler. It describes cron and at to a 'T'.

Welcome. :D Surprisingly, there is documentation supplied with the product, have you checked there? Some suggestions: instconf.pdf Installation and Configuration Guide dsupgde.pdf Install and Upgrade Guide oraoci9.pdf Oracle OCI Stage Guide These and many more are all in the 'Docs' directory under y...