Y currently the schedule table has a problem crossing days. So shorten your window to be all in the same day... so 23-23:59, or 00-01, something like that.
If that doesn't clear it up let me know, but it should.
That did the trick!
Y I figured. I'm gonna work on that in the next version.
Andy Levy
I have a CheckDB job configured to run daily with a begintime of 23:00:00 and endtime of 01:00:00 and excluding databases whose names start with a number ([0-9]%). I set it up late last week and after correcting the Exclude field over the weekend, it did not run as expected last night.
The MinionCheckDB-AUTO ran successfully at 11 PM and I manually triggered it at 11:07 and 11:09. No records appear in CheckDBLog at any of those times. The daily system DB check at 10 PM (Minion default) did run on time, as did a scheduled run for user DBs at 4 AM.
If I run it manually (see below), it runs properly. Is the issue that I'm crossing over midnight with the begin & end times, or should I be looking at something else?
EXEC CTXDBA.Minion.CheckDBMaster @dbtype = 'User', @opname = 'CHECKDB', @stmtonly = 0, @schemas = NULL, @tables = NULL, @include = NULL, @exclude = '[0-9]%', @numconcurrentprocesses = 2, @DBInternalThreads=1, @debug=0 ;