How long does it take to run a subscription ?

[WB_9962145]

 Hola everyone,

I was wondering weither there's a way to find out how long does it take to run a script inside a subscription ?

Thanks in advance

[PaiChung · Accepted solution]

You can turn on system statistics, you may have to have the subscription call a separate service.

Also you can log out or process start and end time in the subscription.

I've done test cases where at sub start I do getDate() and again at the end and subtract those to get the time elapsed.

Then I also do a running average calculation by doing (# of times ran * average + last time) / (# of times ran + 1) 

Then I store the new average and new times ran.

[slangley]

Hi @WB_9962145.

In addition to the points Pai made, you can also look at using the utilization subsystem for gathering statistics in your environment.

Regards.

--Sharon

[slangley]

Hi @WB_9962145.

If you feel your question has been answered, please mark the appropriate response as the Accepted Solution for the benefit of others with the same question.

Regards.

--Sharon