title: Can I schedule a job to run at midnight of each timezone, and how to let the proc know which timezone to process?
body: <p>I have a job that I need to run at midnight for 7 timezones.  Is there a way to create a single schedule to do this in SQL 2008 R2 on Windows Server 2008 R2, that will tell the proc which timezone to process?</p>