T-SQL to Disable/Enable Job in SQL Server 2005
The following query shows the list of jobs running on the sql server.
select * from msdb..sysjobs
From the msdb..sysjobs, the required job_id for enable or disable to be taken.
T-SQL to dis-enable specific job in sql server
EXEC msdb..sp_update_job @job_id = '770F175B-C8A0-4157-BACD-0AF129DF570C', @enabled = 0
T-SQL to enable specific job in sql server
EXEC msdb..sp_update_job @job_id = '770F175B-C8A0-4157-BACD-0AF129DF570C', @enabled = 1
Leave a reply
Related Posts
- Selecting Random Rows from a Table in SQL Server
- Useful SQL Server Management Studio Keyboard Shortcuts
- Case-sensitive check/search/match in T-SQL - Sql Server 2005
- Get AM/PM in Sql Server DateTime Format
- Replace/Remove Special Characters in Sql Server 2005/2008
- Create Linked Server in Sql Server 2005
- Alter/Change new Default Value of a Column in already created Table
- Invoke URL from Sql Server 2005 Stored Procedure
- T-SQL to change schema/owner name in Sql Server
- Delete Statement with inner join in Sql Server 2005
- Transpose Rows to Columns in Sql Server 2005 using PIVOT
- Transpose Columns to Rows in Sql Server 2005 using UNPIVOT
- Split Function in Sql Server to break Comma-Separated Strings into Table
- Delete duplicate rows on table with/without primary key in Sql Server 2005
- Sql server: Special Characters (%,[,]) in LIKE operator using ESCAPE keyword
- Pagination in Sql Server 2005
- Transact-SQL to get description of column in Sql Server 2005 using fn_listextendedproperty
- SQL to Grant EXECUTE permission to all Procedures and Functions
- Search text/string|Find keyword in Sql Server Function and Procedure
- Title case (Proper case) Function in Sql Server 2005
- Cursor For Converting Rows to Column in Sql Server
- Changes Row to Columns (Transpose) in Sql Server 2005 using COALESCE
Do you like this post?
