DSXchange

Thanks for the code. I'll check it out.

I do have a follow-up question related to using an exception handler, though: Is there a way to get the log entries into the body of an email? My exception handler links to a notification and I have the option set to "Include job status in email". But this only includes the results -- the ...

Help for the job sequence properties is clear on how the compilation options work. Yes, it is. The issue was that there is nothing that decribes the interrelationship between this setting and an exception handler. Does the handler work with the setting (it is enabled), or does it replace the automa...

Well, not sure what was happening before but.... In the interest of continuity, I'll include what I found worked: I got it to work. I have the sequence set to "Automatically handle activities that fail" and a model like this: JobTest --OK--> NotifyOk ExceptionHandler ----> NotifyFail And i...

Are your exception handler and the jobs connected? Ummm.... No. :? There doesn't seem to be anyway to link them together as the handler only supports an output link. And from reading other threads on this forum, my understanding is that they are NOT linked together but that the handler catches anyt...

Up til now, I've been using explicit notification stages tied via a trigger to the major job activities. I now have a good understanding of triggers and notifications. :) I've been looking at ways to improve the error handling. I believe using an exception handler may allow me to avoid using explici...

I found nothing in &PH& that was related. I'm still going through the Server logs (when I have time) to try and see what may have started running about that time. Of course, "nobody" started anything new within the last month. :? Funny how Mr. "Nobody" gets around -- my k...

Just wanted to wrap this thread up... I still don't know why -- can't seem to find any cause -- but it turns out to be something related to the time. I moved the schedule time from 2:00am to 2:10am and it succeeds without issue. I've been poring through the logs and have yet to see anything that tel...

As mentioned in my last post, the scheduled parameters are the same ones that have been running successfully for months. And they are the same entered/default parameters used when I run it manually. There are only three entered parameters; the rest are all by defaults. A follow-up: The scheduled ETL...

The ETL is controlled by a master sequence and job parameters are passed from there on down to the main sequence and other jobs and stages. The parameter values have not changed (they were entered during the scheduling of the job months ago). Other jobs within this ETL that access the same server su...

I am an admin for both the source server and the DataStage server so I have already confirmed that it is available. There are more recent releases of this same ETL which are running on a different DataStage server (our dev/test server), though scheduled to run about an hour later in the morning. The...

The 80004005 means that the server/database wasn't reachable. It is a catch-all error in that, whatever doesn't fit into one of the specific errors (e.g., 80040e4d login Failed for User '(Null)', 80040e09 access denied, etc.) ends up with an 80004005. Basically, it means "we could not connect a...

Our production ETL has begun aborting while scheduled. I can run the same ETL manualy and it succeeds without error. It has been running for months without issue and no changes have been made since long before this began occurring. So I am confident this is not a problem with Ascential or the ETL --...

Have you had experience taking a SQL Server text column (source) to an Oracle data type (target) and care to share your experience? I've read several articles and most indicate the near-equivalent to a SQL Server text data type is an Oracle LONG. But given the LONG restrictions (not available in a W...

So a shared container is really just like including code from a shared library; e.g., a set of code that gets compiled into the overall module. You can use that code (and run it) in as many modules as you choose because each one gets its own copy at compile time. I just wasn't clear whether the cont...