Log to file

chulett · Post by **chulett** » Wed Feb 15, 2012 8:42 am

The only way to know would be to open a support case. If you are seeing this behaviour across multiple jobs (rather than just a specific one) then that would be the next step that I would suggest.

mdbatra · Post by **mdbatra** » Wed Feb 15, 2012 12:50 pm

Is there any way in BASIC to fetch the log based on the start and end time ?

mdbatra · Post by **mdbatra** » Wed Feb 15, 2012 1:05 pm

As i was building the functionality only for the adhoc failure requests, what i have designed is to provide the Latest start event id as a parameter(but manually, from the job log)

So, for time being i have this workaround. would work out in detail later and share the updates.

Thanks all for your kind suggestions.

chulett · Post by **chulett** » Wed Feb 15, 2012 2:07 pm

mdbatra wrote:Is there any way in BASIC to fetch the log based on the start and end time ?

From what I recall the answer is yes, but I don't have my documention handy to check at this moment.

pandeesh · Post by **pandeesh** » Wed Feb 15, 2012 2:14 pm

i have tried to get the correct start event id..but it's going in an infinite loop.

Code: Select all

$INCLUDE DSINCLUDE JOBCONTROL.H
hj=DSAttachJob(Jobname,DSJ.ERRFATAL)
START_ID=DSGetNewestLogId(hj,DSJ.LOGRESET)
END_ID=DSGetNewestLogId(hj,DSJ.LOGANY)
Valid=1
a=START_ID-1
LOOP
WHILE valid<>0 DO
   Detail=DSGetLogEntry(hj,a)
   EventType=Field(Detail,"\",3,1)
   if EventType = "DSJ.LOGSTARTED"
   then
      begin=a
      valid=0
   End
   else
      valid=1
      a-=1
   END
REPEAT
Ans=begin:" " :END_ID

ray.wurlod · Post by **ray.wurlod** » Wed Feb 15, 2012 3:10 pm

Remove the quotes from around DSJ.LOGSTARTED. This is a predefined integer constant. By making it a string constant you will never succeed in matching the value. Therefore you have an infinite loop.

pandeesh · Post by **pandeesh** » Wed Feb 15, 2012 11:09 pm

Thanks Ray!After removing the quotes also, it's still going in an infinite loop.
i need to investigate .

ray.wurlod · Post by **ray.wurlod** » Thu Feb 16, 2012 12:19 am

Add an extra exit condition from the loop, such as WHILE a > 0.

chulett · Post by **chulett** » Thu Feb 16, 2012 12:31 am

Also be more careful with your variable names, "valid" and "Valid" are two different variables.

pandeesh · Post by **pandeesh** » Thu Feb 16, 2012 12:36 am

Thanks Ray.. I ll check it shortly since I am in a travel.
But what I believe is the loop will exit once it finds the proper start event .
Because valid=0 once it finds the start event .
The loop will work only when valid<>0.
Correct me if I am wrong .
Thanks.

pandeesh · Post by **pandeesh** » Thu Feb 16, 2012 12:50 am

Yes craig.. There's a mismatch . I ll change that and check .

kandyshandy · Post by **kandyshandy** » Thu Feb 16, 2012 1:40 am

There is another way to achieve this...

Use DSGetLogEventIds... To get the details of latest run, just pass 0 as RunNumber

pandeesh · Post by **pandeesh** » Thu Feb 16, 2012 2:02 am

Sure kandy!I ll check that too! :D

pandeesh · Post by **pandeesh** » Thu Feb 16, 2012 2:04 am

Modrators,

Don't feel that i am hijacking the thread. I am trying to provide the proper solution for badra(the same issue i have faced earlier).

Thanks

pandeesh · Post by **pandeesh** » Thu Feb 16, 2012 5:55 am

Success!! It works fine now..

Code: Select all

$INCLUDE DSINCLUDE JOBCONTROL.H

hj=DSAttachJob(Jobname,DSJ.ERRFATAL)

START_ID=DSGetNewestLogId(hj,DSJ.LOGSTARTED)
END_ID=DSGetNewestLogId(hj,DSJ.LOGANY)

valid=1
a=START_ID-1

LOOP
WHILE valid<>0 DO
Detail=DSGetLogEntry(hj,a)
EventType=Field(Detail,"\",4,1)[1,5]
if EventType="Start"
then
begin=a
valid=0
End
else
valid=1
a-=1
END
REPEAT
Ans=begin:" " :END_ID

@Badra,

The above will give you the start and end id, so that you cna loop through.