Thanks for the prompt reply.

I actually performed step 1 and created the stored procedure at the Master level and added a job step to EXEC the SP. However, when the job ran this morning when it reached that step, the job failed because it couldn't find the table that was being updated in the SP (it doesn't exist in the Master database, obviously.)

Therefore, I thought your step 2 was the only option left to me. It sounds like the simplest way to go. Thank you!