Multi instance job

mallikharjuna · Post by **mallikharjuna** » Mon Dec 22, 2014 8:01 am

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

chulett · Post by **chulett** » Mon Dec 22, 2014 8:24 am

1. Yes.
2. DSGetLinkInfo() with the DSJ.LINKROWCOUNT InfoType.

Both show the number of insert requests made.

mallikharjuna · Post by **mallikharjuna** » Mon Dec 22, 2014 8:35 am

Thanks Chulett. I have executed 2 times,i want to find previous execution record count.

chulett · Post by **chulett** » Mon Dec 22, 2014 8:49 am

That's a different question... check in the job's log for that run.

mallikharjuna · Post by **mallikharjuna** » Mon Dec 22, 2014 8:52 am

I have checked ds log for that run. only i am able to see insert query,not able to find the insert record count.

chulett · Post by **chulett** » Mon Dec 22, 2014 10:37 am

No way for me to check, seem to recall a summary at the end of the log entries which would have all that.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 22, 2014 1:56 pm

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.

ArndW · Post by **ArndW** » Fri Dec 26, 2014 1:53 am

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.