DSXchange

Documented here. Note the first prerequisite, guessing you are not.

I don't see that as a problem. Can you tell me why you think it is? Curious what I might be missing.

As to your second sentence, show us what you are actually doing. Full disclosure. There was no mention of other fields in your posted example, which was why I answered you as I did.

So... are you resolved here or is there something more you need?

You could use a Server job and USERSTATUS. Or a routine using DSExecute to run either a script (more control) or call sqlplus directly.

Is this script on your ETL server? Does the job's executing user have the permissions it would need to run it?

Okay... and?

I doubt it would help in this circumstance but it's always good to be current on your fixpacks.

Have you not tried the 'Where used' option? You'd need the metadata for the hashed file in the repository for that, however... is it?

No clue. Have you asked your DBA?

Simplest way to check is to try it.

You'll have to "use" all of the output links in some manner.

So... you ARE on a grid? If so, does this error happen on a specific node? For the record, I am not talking about the credentials you are using. I'm talking about the environment in both cases, the collection of values like $ORACLE_HOME, path, shared library (etc) that exist when the job runs or whe...

Not sure you understood. When you run a job, what user actually executes it? Meaning, the engine credentials in the web console.

So what's different between your environment and the environment of the user that runs the job? ORACLE_HOME perhaps? TNS_ADMIN? Something is.

As a first guess with all those write failures - you ran out of space.

Welcome. Hint - The first day of the previous month is "1". :wink: The old trick for the last day of the previous month is to set an internal value to the first day of the current month and then subtract 1 day from it for the EDate. Then rebuild it with a day of 1 for the SDate. All of thi...