microsoft
Exclude Tables
Is there a way to Exclude tables from being analyzed, updated, etc?
It would be nice to have a parameter that would accept a list that indicated a specific list of tables to exclude. As well as a parameter that accepted a list to of tables to run, rather than the @tblName parameter which accepts one table at a time. This would be better because it would utilize the timeout feature for the list of tables.
What I am trying to do is exclude a specific set of tables from a run, then have a second jobs that run the list of tables. I have a couple very large tables (billions of rows) that take a long time to process and then the job times out. This results in a majority of the tables not getting updated. I would like to be sure all the rest of the tables are updated, then have a second job that updates the large tables.
