olahallengren / sql-server-maintenance-solution

SQL Server Maintenance Solution
https://ola.hallengren.com
MIT License
2.91k stars 756 forks source link

Default behaviour per table - at least for skip #574

Open assaff opened 3 years ago

assaff commented 3 years ago

Hi Ola, First, thanks for the hard work for the community

My idea is simple to have a predefined table where I can put for specific tables a default behaviour from limited choices (like skip, online).

The usual procedure will do LEFT JOIN to this table to get a potenially diffrent behaviour.

Justificaion - very useful in cases where small anount of tables needs specific behaviour or scheduling that would be treated in separate jobs.

Regards Assaf Fraenkel (MCS Data architect, Microsoft Certified Architect)