Server routine help needed

sagar deshmukh · Post by **sagar deshmukh** » Tue Apr 12, 2011 5:09 am

Hi ,

I have written a routine to extract the Fatal error logs and send it through mail.

Routine is as follows : -

$INCLUDE DSINCLUDE JOBCONTROL.H 

***CallingProgName = DSJ.ME

rJobHandle = DSAttachJob(Jobname, DSJ.ERRNONE)
JobStartTime = DSGetJobInfo(rJobHandle, DSJ.JOBSTARTTIMESTAMP) 
JobEndTime = DSGetJobInfo (rJobHandle, DSJ.JOBLASTTIMESTAMP)


SummaryArray = DSGetLogSummary(rJobHandle, DSJ.LOGFATAL, JobStartTime, JobEndTime, 0)


Mail = DSSendMail("From:DataStage-Development@winn-dixie.com\nTo:Sagardeshmukh@winn-dixie.com\nServer:wdims\nSubject:rJobHandle Failed !\nBody:SummaryArray")


DetachResult = DSDetachJob(rJobHandle)

Ans = Mail

All I want is the Mail content should be the all Fatal error for perticular job but I am getting "SummaryArray" as mail content instead of value of "SummaryArray" which will be the error logs for that perticular job.

Values of "SummaryArray" is not getting passed as a parameter. could you please help me out regarding this.

Thanks
Sagar.

pandeesh · Post by **pandeesh** » Tue Apr 12, 2011 5:44 am

Values of "SummaryArray" is not getting passed as a parameter

may i know where and how you are passing that as a parameter?

sagar deshmukh · Post by **sagar deshmukh** » Tue Apr 12, 2011 5:48 am

Hi,

Sorry for wrong words,

1)I am getting error logs as below :

SummaryArray = DSGetLogSummary(rJobHandle, DSJ.LOGFATAL, JobStartTime, JobEndTime, 0)

these error logs captured in "SummaryArray" needs to pass to the below DSSendMail , which is not happeing here....

Mail = DSSendMail("From:DataStage-Development@winn-dixie.com\nTo:Sagardeshmukh@winn-dixie.com\nServer:wdims\nSubject:rJobHandle Failed !\nBody:SummaryArray")

pandeesh · Post by **pandeesh** » Tue Apr 12, 2011 6:05 am

So, in the mail body whats getting passed?

SummaryArray or null?

sagar deshmukh · Post by **sagar deshmukh** » Tue Apr 12, 2011 6:18 am

Hi,

I am geting mail like this :

Code: Select all

-----Original Message-----
From: DataStage-Development@.com [mailto:DataStage-Development@.com]
Sent: Tue 4/12/2011 7:33 AM
To: Sagar Deshmukh
Subject: rJobHandle Failed !
 
SummaryArray

chulett · Post by **chulett** » Tue Apr 12, 2011 6:21 am

That's because it's inside quotes and thus just text. Build the string properly so it can be resolved:

...Failed !\nBody: " : SummaryArray )

sagar deshmukh · Post by **sagar deshmukh** » Wed Apr 13, 2011 4:09 am

Thanks A lot this really helped.