We have a server “Program” document to run the Compact task on all databases with more than 20% whitespace (“-S20”) on the server each morning at 3AM.
However, there is one database that we would like to exclude from that Program, since it is 13GB and is compacted each Sunday instead.
I know that you can explicitly specify the folder on which Compact should run, but can you specify multiple folders? The database I wish to exclude resides in its own folder, so that would be ideal. However, I don’t want to have to create multiple Program documents just to cover all of the other folders.
Ideally, I would love to have an additional field on the Program document that allows you to define the database(s)/folder(s) that is excluded from the program.
Does anyone have any suggestions?
Cheers!
T.