• here is a solution for jobs

    we have some dev sql servers where the developers make their own sp's and keep there. rule is that anytime someone wants a new copy of a db we restore from backup because it's too much to copy over the data. sometimes the devs forget to back up their stuff because we don't backup dev and qa.

    i had an idea to make a sql server with blank db's with the same names as prod and copy all jobs and sp's there for backup.