DSXchange

Thanks Prasson , I am trying to get all the "Info" event type with the below code eventDetail = DSGetLogEntry(hJob1,eventID) evtDate = FIELD(eventDetail,"\",1) evtDate = CHANGE(evtDate,"Date: ","") evtMessage = FIELD(eventDetail,"\",4) evtType = Fiel...

Suggest me is there a way i can achieve the above requirement using routine which will get the entire log rather than the latest event id and event detail for that.

craig,

i am trying to using dsgetnewestlogid() ...

Dear All, I tried to extract the log using below routine. Here i am able to fetch the last row which will have the job status log entry. $INCLUDE DSINCLUDE JOBCONTROL.H JobName = Arg1 hJob = DSAttachJob(JobName, DSJ.ERRNONE) LatestStartId = DSGetNewestLogId(hJob, DSJ.LOGSTARTED) LatestLogId = DSGetN...

could any one suggest me on this..

Dear All, I have a sequence which is calling jobs/sequences and with trigger condition with warning-conditional link to SEQUENCER with ANY mode and the SEQUENCER linked to Routine Activity which is calling UtilityAbortToLog and sending message using notification activity. so whenever Warnings occur ...

Arndw

Could you please suggest me an other way to get the error message from the job sequence in email notification.

Dear All, I have 10 job activities which are having OK Conditional and otherwise trigger conditions. Otherwise trigger condition link for all job activities linked up to sequencer with Any mode. I have also connected exception handler to the sequencer and then Email Notification activity. I am addin...

Dear All,

I need to create an xml file with column value from Database table in the file name for example 001_test.xml,002_test.xml where 001 and 002 are fetching from table field name FID.

Looking farward for the suggestion how can i proceed for this.

Arndw, Routine activity return log entries are : 01:12:36: Routine_Activity_212 (ROUTINE DSU.rtneventrmsg) started 01:12:36: Routine_Activity_212 finished, reply= there is no reply code specified in the log. I removed routine activity and called the routine in user variable activity . I connected th...

Arndw,

when i test this routine it returns the fatal error when ever job aborts otherwise returns empty string.

also the options which you specified are not checked.

do i have to check these two options?

Dear All, I am using the below routine in job sequence using routine activity which is added after sequencer which will have links multiple jobs for failed notifications.when ever adding this rouine activity there is an executing command activity which is calling a datastage job is failing and total...

Can we link routine activity after sequencer stage in job sequence

Anrnw,

What basic api function will be helpful to extract the error mesage

Hi

My membership is expired and will renew in a week.

I am unable to see the remaining post send by craig.

Request you to please give the solution for the error message issue.