Is there a tool to automate running a process on every database every day
We have tried to set up a job that uses sp_MSForeachDB to run the same stored procedure on every database in our system but we run into issues with permissions or SQL statement being truncated. When we run the same job using MultiScript it works perfectly but do not want to have to manually execute that process every day. Is there a RedGate tool that can be used to automate a job like that?
0 · Share on Twitter