Minion Reindex job is scheduled to run on weekly basis and is running fine but the log is showing nothing against last a few runs. Does this mean that it's doing nothing? Does anybody know what might be the reason?
So has logged its work in the past? It’s just stopped logging in the last few runs?
If that’s the case, then I’d say that it appears as though nothing needs to be done so there’s nothing to log.
However, if you’d like to test it then run it with @StmtOnly = 1 and see if any statements show up in the Messages tab of SSMS.
If not then it looks like you’re good to go. If something does show up, the run it again with @StmtOnly = 0 and see if the expected rows show up in the log.
Well, we know the routine works because you were able to process and log tables manually. If it still isn’t logging properly when it runs automatically then my best guess would be permissions? Maybe the agent acct has had a permissions change, or maybe the job owner was switched to someone who doesn’t have perms. I’d say make sure the job is owned by sa or by you and see how that goes. Currently the routine doesn’t log when it can’t log a row, because where would it log it?
When you ran it manually about how many tables were processed? Was it a lot or just a small handful. If it were just a handful it’s possible it hasn’t needed to do anything. If it were a lot then it’s possible you’re having the issue above. Let me know what happens and if it continues I’ll try to come up with a way to help you ferret this out.
I haven’t heard back from you on this.
Closed due to inactivity.