I have a stored procedure in production which is run every mins and update the result into a table. The stored procedure is called from internal application. It takes to run 39 seconds.
It always stops updating the table after mid night everyday. After mid-night, the stored procedure returns 0s because we have no activities in db. Beginning from 5 am, we have activities in db. Anyone give me advice?
Thank you.