Asger Blond
ab-mi at post3.tele.dk
Wed Jul 9 08:43:29 CDT 2008
msdb Asger -----Oprindelig meddelelse----- Fra: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] På vegne af Arthur Fuller Sendt: 9. juli 2008 15:02 Til: Discussion concerning MS SQL Server Emne: [dba-SQLServer] SQL Agent Jobs Where do SQL Agent jobs live? In master? In msdb? Somewhere else? I have a pretty smart restore script set up now that does a restore and then recreates some users etc. but it is unaware of jobs, and I want to figure out how to automate that part as well. Any ideas? TIA, Arthur _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com