Sorry, but there are no more tags available to filter with.
-
I was 'trying' to delete an obselete SQL Server Agent job until this nice error popped up: TITLE: Microsoft SQL Server Management Studio ------------------------------ Drop failed for Job 'Optimiser.Subplan_1'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink...
-
I wonder why I couldn't find a script on the Internet which generates statements to execute all jobs in the same job category. The only reason I could think of is that it's simple to write so here goes my version SET NOCOUNT ON USE tempdb GO DECLARE @Category AS VARCHAR ( 255 ) SET @Category = 'Database...