DSXchange

Ray I couldn't agree with you more. I'm surprised they don't have the same issues with other environments they host. My thought was dropping a trigger file that their process use to start the copy. I'm not sure though that the software they are using isn't corrupting the log files. They are using Vi...

Sorry about that I missed the other question. Yes they have been copying the files while jobs are running. At the most you would have three sequencers and one server job running at one time. I've never worked in DS Administration or the tech side of things. Would that mess up more then just what is ...

Our DataStager environment is hosted by a third party and is trying to setup fail over to a remote site. They are having problems with log file corruption when copying files. What are the best practices for copying over log files and keeping them in synch? Any known issues in using Vice-Versa softwa...

Can the DBMS_SNAPSHOT.REFRESH command be run from DataStage 7.5.2?

I've tried the Oracle 8i plug-in and the ODBC connectors and keep getting ORA-00900: invalid SQL statement

Is there a different plug-in I should be using.

BEGIN
DBMS_SNAPSHOT.REFRESH ('PS_UNFI_LEDGER_FID', 'c');
END;

Can the DBMS_SNAPSHOT.REFRESH command be run from DataStage 7.5.2?

I've tried the Oracle 8i plug-in and the ODBC connectors and keep getting ORA-00900: invalid SQL statement

Is there a different plug-in I should be using.

Is there any way of attaching this log file entry to an email.

It would be a great way to check the status of all server job steps in a sequence.

I would like to email a file attachment only if the number of rows is greater than zero.

If someone has done this with Version 7 I would greatly appreciate to know how.