title: Running Stored Procs on Different Databases through Agent Job
body: <p>I have a list of three stored procedures that need to be ran daily on a number of separate SQL databases. Each database is named differently, but the stored procedures on each are the same.</p>
  
  <p>I have extremely limited knowledge on anything other than basic queries, but was thinking I could have a SQL Server Agent job on a database I set up as Master. Then I have that server push that job to the other databases once I configure those as Targets. My issue is that in thinking through this, the database names are different and within the SQL Server Agent wizard I can only set the database to what's currently on master instance.</p>
  
  <p>What would be the best approach to executing this looping through servers to run the stored procs?</p>