Common code for database jobs

1 Declare @backup nvarchar( -)2 Declare @file nvarchar( -)3 Declare @DeleteFile nvarchar( -)4 DeclareDatebakcursor  for5 Select [Bak]='Backup Database'+QuoteName(Name)+'to disk ="'F:\DabaBaseBackup\BU2\'+Name+'\'+Name+'_'+Convert(varchar(8),getdate(), the)+'. bak"'With Init',[file]='Master.dbo.xp_create_subdir N"'F:\DabaBaseBackup\BU2\'+Name+" '"6,[DeleteFile]='master.dbo.xp_delete_file 0,n"'F:\DabaBaseBackup\BU2\'+Name+" ", N"'Bak"', N" "+Convert(varchar( -),DATEADD( Day,-Ten,GETDATE()),126)+" '"7  fromMaster.. sysdatabaseswhereName like 'kr_%'8 OpenDatebak9 Fetch Next  fromDatebak into @backup,@file,@DeleteFileTen  while @ @fetch_status=0 One     begin A         EXECUTE(@DeleteFile) -         EXECUTE(@file) -         EXECUTE(@backup) the         Fetch Next  fromDatebak into @backup,@file,@DeleteFile -     End - CloseDatebak - deallocateDatebak + GO

Common code for database jobs