Custom Search
- Home
- Sql Server
- T-SQL to Disable/Enable Job in SQL Server 2005
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
Related Posts
- 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
Leave a reply
Do you like this post?
