DSXchange

I don't have any PX knowledge unfortunatley and have only been using DataStage in anger for 4 months now - I'll get there however.

I do remember the views in and around Nice being very pleasant on the eye (as I'm sure the wife did as well).

Cheers Arnd - that worked a treat. Your help has saved me countless hours in the past few weeks and is very much appreciated. Gets me thinking about one of my favourite holiday destinations (Nice) every time you reply - visited the the last two years and I can taste the Leffe !!!! Still don't know w...

I am using DSGetLogEntry to pull back Server Job information from the Director Log and am noticing some extra characters being returned - I'm hoping that there is a simple explanation for this. The (abbreviated) code I have is as follows: MAXREJ = 0 getsummary = DSGetLogSummary(JobHandle, DSJ.LOGANY...

Thanks Arnd - guess I'm a poor reader - I did go through the options - thread closed !!!!

I've had a play at creatinf a finish time and am using the TIMEDATE() function. It doesn't matter if this is a few seconds ahead of when the Server Job finished. I already have the DSJ.STARTTIMESTAMP value so I only need the finish datetime. Unfortunately TIMEDATE() returns the date as hh:mm:ss dd m...

I've built in your suggestion Arnd for the start time and it works as you said - I'll keep the GetNewestLogId for warnings and fatal messages as I need to get the exact log messages. Is there anyway to get the Job Finished time so that I could pass this and the start time as values into DSGetLogSumm...

Cheers Arnd I'm also pulling out control types info/warning/fatal - this is related to the thread where our Company does not support Job Sequences. In order for me to use the Job Sequences to be supported I'm having to pull out the log information from a Server Job on failure hence the commands I am...

I am using DSGetNewestLogid (in conjunction with DSGetLogEntry) for DSJ.LogStarted and this returns the latest "control" type from the Director Log. This is as stated in the BASIC manuals. I expected this to return the start time of the Server Job in question but unfortunatley for me the r...

Sorry for not replying to this as I was out of the office Mon/Tues. This worked a treat and has saved me a lot of time.

cheers

I am getting a warning when I run my Job Sequence or the underlying Server Job that I was not getting before. My code hasn't changed but my Job Sequence process is now failing due to this unexpected warning. If I run my underlying Server Job - Sybase_OC --> Sequential File then all of the rows that ...

Sorry Arnd, I missed these lines out warning = DSGetNewestLogId (JobHandle, DSJ.LOGINFO) call DSLogInfo(warning, "WARNING") warning does return a value. I ran the underlying Server Job in standalone mode and it extracted all of the rows that I expected but in the Director Log the following...

I'm getting this error when after I run the final DSLogInfo in the code below. It is in the output of the DSGetLogEntry. If I comment out this code then a similar message is displayed for a routine further down in Job sequence- seems to point towards a network issue/listener file/host file or I supp...

Thanks ArndW - I will give this a try when I stop getting the following error job_seq4..JobControl (GETLOGENTRY ROWS): 2005-05-20 06:22:07\palmeal\2\DSD_SendEvent.B:Error Starting run Cmd = SH -c'ActivityCmd START -file MSEVENTS/20050520062206000' Output = ERROR: Couldn't get I/O for the connection ...

This is a continuation of the thread http://www.dsxchange.com/viewtopic.php?t=92923 but I need one final bit of help to close this topic off. I have managed to pull data from the Director Log which I now want to write out to a text file. The commands that I have used to pull out the information that...

I have yet decided what way to do this yet - the log alerts method would probably be the best for me in order to keep my job sequences but whatever way I do this I have to be able to pull data from the Director Logs. I've been having a play with some of the basic commands for getting informastion ou...