Page 1 of 1
Multi instance job
Posted: Mon Dec 22, 2014 8:01 am
by mallikharjuna
Hi,
i am using multi instance job.is it possible to check how many records are inserted in table from director?
also please let me know what are the other options to check the records inserted in table without using query.
Thanks in advance
Posted: Mon Dec 22, 2014 8:24 am
by chulett
1. Yes.
2. DSGetLinkInfo() with the DSJ.LINKROWCOUNT InfoType.
Both show the number of insert requests made.
Posted: Mon Dec 22, 2014 8:35 am
by mallikharjuna
Thanks Chulett. I have executed 2 times,i want to find previous execution record count.
Posted: Mon Dec 22, 2014 8:49 am
by chulett
That's a different question... check in the job's log for that run.
Posted: Mon Dec 22, 2014 8:52 am
by mallikharjuna
I have checked ds log for that run. only i am able to see insert query,not able to find the insert record count.
Posted: Mon Dec 22, 2014 10:37 am
by chulett
No way for me to check, seem to recall a summary at the end of the log entries which would have all that.
Posted: Mon Dec 22, 2014 1:56 pm
by ray.wurlod
You have to find the previous run FOR THAT INVOCATION. If there have been many runs with different invocations that particular previous run may already have been purged.
Posted: Fri Dec 26, 2014 1:53 am
by ArndW
To add to what Ray has stated, if you do a DSAttachJob() to "MyJob" you will get a handle pointing to information for the last run, if you attach to "MyJob.InvocationName" then you will get information for that invocation.