How long does it take to run a subscription ?
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
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
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.