Category Archives: dos
How to: Disable or Enable a SQL Server Job Programatically
How to: Disable or Enable a SQL Server Job Step 1: Find the JobId SELECT job_id,name,description,enabled FROM msdb.dbo.sysjobs ORDER BY name ASC Step 2: Update the enabled flag – Disable SQL Job DECLARE @my_job_id UNIQUEIDENTIFIER SET @my_job_id = ’1CB89951-9ED1-45F2-A5E8-A20D9164613F’ EXEC sp_update_job @job_id
How to: Disable or Enable a SQL Server Job Programatically
How to: Disable or Enable a SQL Server Job Step 1: Find the JobId SELECT job_id,name,description,enabled FROM msdb.dbo.sysjobs ORDER BY name ASC Step 2: Update the enabled flag – Disable SQL Job DECLARE @my_job_id UNIQUEIDENTIFIER SET @my_job_id = ’1CB89951-9ED1-45F2-A5E8-A20D9164613F’ EXEC sp_update_job @job_id
Deploying changes to multiple SQL Server Environments
I am a bit old school when it comes to working with databases. I know it’s so easy to just jump into SSMS or Query Analyzer to do ones job so fast and nifty, but I like to have scripts handy
Deploying changes to multiple SQL Server Environments
I am a bit old school when it comes to working with databases. I know it’s so easy to just jump into SSMS or Query Analyzer to do ones job so fast and nifty, but I like to have scripts handy
