Capturing part of job log using routine

Roopanwita · Post by **Roopanwita** » Tue May 27, 2008 12:06 am

Hi,

I want to capture part of job log(e.g - job has finished /aborted - with error msg line) using a DS ROUTINE.
My actual requirement is ,in a Sequence I m sending a mail notification after successful competion of process & if it abort in any intermediate stage ,then it send a failure msg.
Rather than going into job log ,i want to know it from mail msg.

Thanks in advance

ArndW · Post by **ArndW** » Tue May 27, 2008 1:29 am

The routines you need to use are:

DSAttachJob()
DSGetJobInfo()
DSGetLogSummary()
DSGetLogEntry()
DSDetachJob()

Roopanwita · Post by **Roopanwita** » Tue May 27, 2008 1:36 am

bkumar103 · Post by **bkumar103** » Tue May 27, 2008 1:43 am

what is the problem you are getting? Is it running properly?

Roopanwita · Post by **Roopanwita** » Tue May 27, 2008 2:11 am

I am unable to compile this routine.

Then if I m using in Routine Activity,do I need 2 pass value of arguments?

ArndW · Post by **ArndW** » Tue May 27, 2008 4:23 am

Did you declare this as a routine or a before/after job routine? There is a big difference. What is your compiler error?

thumati.praveen · Post by **thumati.praveen** » Tue May 27, 2008 5:15 am

Roopanwita wrote:Hi,
I wrote a Routine

$INCLUDE DSINCLUDE JOBCONTROL.H
Ans=0
Erroid = 0
ErrorDetail=0
JobName= ' '
handleJob = DSAttachJob(JobName, DSJ.ERRNONE)
If NOT(handleJob) Then
Errorid = -99
End
Else
/*Ans = DSGetJobInfo(handleJob, DSJ.LOGFATAL) */
Errorid = DSGetNewestLogId (handleJob, DSJ.LOGFATAL)
EventDetail = DSGetLogEntry(JobHandle, DSJ.LOGFATAL)
End
DetachResult = DSDetachJob(handleJob)

But it is not working.
Can you help me to fix it.

Thanks in advance.

Change the EventDetail = DSGetLogEntry(handleJob, DSJ.LOGFATAL)

JobHandle not declared before

thumati.praveen · Post by **thumati.praveen** » Tue May 27, 2008 5:18 am

what you want to output ErrorID or ErrorDetail ?

assign These variable to Ans.

Roopanwita · Post by **Roopanwita** » Tue May 27, 2008 5:49 am

Roopanwita · Post by **Roopanwita** » Tue May 27, 2008 5:50 am

thumati.praveen · Post by **thumati.praveen** » Tue May 27, 2008 6:03 am

Roopanwita wrote:I want Error detail
My code looks like

$INCLUDE DSINCLUDE JOBCONTROL.H
Ans = 0
Errorid=0
ErrorDetail=0
jobname=' '
handleJob = DSAttachJob(JobName, DSJ.ERRNONE)
If NOT(handleJob) Then
Errorid = -99
Ans = DSGetJobInfo(handleJob, DSJ.LOGFATAL)
Errorid = DSGetNewestLogId (handleJob, DSJ.LOGFATAL)
EventDetail = DSGetLogEntry(handleJob, DSJ.LOGFATAL)
End
DetachResult = DSDetachJob(handleJob)
/*Reply = DSSendMail(Ans)*/

DSGetLogEntry() This function requires two parameters one is job name anithor one is EventID .

DSGetLogEntry(handleJob, Errorid) use this it should work now.

and finally assign the Ans to EventDetails

chulett · Post by **chulett** » Tue May 27, 2008 6:37 am

Are you aware that if you simply 'Include job status' in the email, the last message in the email will be from the failed job and the error will be in the email as well?

Roopanwita · Post by **Roopanwita** » Tue May 27, 2008 7:08 am

My requirement is to post Error msg by mail,in case of job failure.I coudn't get your msg.
Can you explain it again.

chulett · Post by **chulett** » Tue May 27, 2008 7:18 am

Notification Activity. 'Include job status' option. Try it, see if it gets you what you want without all that extra who-ha.

Roopanwita · Post by **Roopanwita** » Tue Jun 03, 2008 11:44 pm

Hi,
Thanks for help.
I have checked with Notification Activity Stage. It sends the status msg (like finished successfully/finisished with warning/Aborted) only.

I want to capture the error msg line(in case of fatal error) from the job log, so that in case of job failure i can understand the reason of failure rather than going & checking it from job log...