Currently we have a rather elaborate backup job we run nightly on a very large reporting server.
We do our backups and for the databases we aren't backing up (due to them being replicated from a live server) we run a T-SQL CHECKPOINT on them. All in all, with every every step, this is over 157 steps. And when we add a new database, it's quite elaborate adding it in since we try to keep things alphabetized.
I've been building a SSIS package so all I have to do is fix 1 line of code to add a new database. This part works great! I won't go into detail with this other then it works very well.
I want to add the next step to this which is a loop that will read t-sql code and get a list of replicated databases that we run CHECKPOINT on. Now to be clear...this is NOT the checkpoint package within SSIS. This is the t-sql code "CHECKPOINT".
I've added a "Execute SQL Task" that is within a Sequence container, which is housed within a ForEach Loop Container, that reads from a "Execute SQL Task". The looping works fine. I have the t-sql CHECKPOINT within my "Execute SQL Task" but I'm not 100% sure if this working right.
So this leads me to several questions:
1. Will this work?
2. Is there a way to check to see if my CHECKPOINT ran on my list of databases?
3. If this isn't the right way, how would I do it?
I hope this makes sense for everyone.
Thank you for your time.
SQL Server 200x Newb and proud of it! :-D