SQL Server: Ola Hallengren Scripts of Agent Jobs
USE [msdb] GO /****** Object: Job [DatabaseBackup - SYSTEM_DATABASES - FULL] Script Date: 08/31/2012 13:34:10 ******/ BEGIN TRANSACTION DECLARE @ReturnCode INT SELECT @ReturnCode = 0 /****** Object: JobCategory [Database Maintenance] Script Date: 08/31/2012 13:34:10 ******/ IF NOT EXISTS ( SELECT name FROM msdb . dbo . syscategories WHERE name = N'Database Maintenance' AND category_class = 1 ) BEGIN EXEC @ReturnCode = msdb . dbo . sp_add_category @class = N'JOB' , @type = N'LOCAL' , @name = N'Database Maintenance' IF ( @@ERROR <> 0 OR @ReturnCode <> 0 ) GOTO QuitWithRollback END DECLARE @jobId BINARY ( 16 ) EXEC @ReturnCode = msdb . dbo . sp_add_job @job_name = N'DatabaseBackup - SYSTEM_DATABASES - FULL' , @enabled = 1 , @notify_level_eventlog = 2 , @notify_level_email = 0 , @notify_level_netse