1) Use below procedure to start the Job in SQL
Exec msdb.dbo.sp_start_job @job_name = N'Job_Name'
Example:
Exec msdb.dbo.sp_start_job @job_name = N'Job_Name'
Exec msdb.dbo.sp_start_job N'Job name'
2) Use below procedure to stop the Job in SQL
Exec msdb.dbo.sp_stop_job @job_name = 'Job_Name'
Example:
Exec msdb.dbo.sp_stop_job @job_name = N'Job_Name'
OR
Exec msdb.dbo.sp_stop_job N'Job name'
3) Use below procedure to enable or disable the Job in SQL
To enable the Job:
EXEC msdb.dbo.sp_update_job @job_name = N'Job_Name', @enabled = 1
To disable the Job:
EXEC msdb.dbo.sp_update_job @job_name = N'Job_Name', @enabled = 0
Exec msdb.dbo.sp_start_job @job_name = N'Job_Name'
Example:
Exec msdb.dbo.sp_start_job @job_name = N'Job_Name'
OR
Exec msdb.dbo.sp_start_job N'Job name'
2) Use below procedure to stop the Job in SQL
Exec msdb.dbo.sp_stop_job @job_name = 'Job_Name'
Example:
Exec msdb.dbo.sp_stop_job @job_name = N'Job_Name'
OR
Exec msdb.dbo.sp_stop_job N'Job name'
3) Use below procedure to enable or disable the Job in SQL
To enable the Job:
EXEC msdb.dbo.sp_update_job @job_name = N'Job_Name', @enabled = 1
To disable the Job:
EXEC msdb.dbo.sp_update_job @job_name = N'Job_Name', @enabled = 0
No comments:
Post a Comment