DEFINITIONS
Definitions More Info.
Definition ID
85
Title
SQL
Category
SCRIPT
Definition
JOB_ENABLE_DISABLE ETMEK_MAINTANENCE_ICIN
Definition Description
--joblar disable ediliyor.
-- Once durdurmak istediğimiz jobı durduruyoruz
EXECUTE [msdb].[dbo].[sp_stop_job] N'cdc.GURMEN_capture'
-- sonra jobları disable ediyoruz
EXECUTE [msdb].[dbo].[sp_update_job] @job_name='cdc.GURMEN_capture', @enabled =0
EXECUTE [msdb].[dbo].[sp_update_job] @job_name='DBA_CDC_For_Postgres', @enabled =0
EXECUTE [msdb].[dbo].[sp_update_job] @job_name='DBA_CDC_InsertLateRecords_DBALog', @enabled =0
-- enable part
EXECUTE [msdb].[dbo].[sp_update_job] @job_name='cdc.GURMEN_capture', @enabled =1
EXECUTE [msdb].[dbo].[sp_update_job] @job_name='DBA_CDC_For_Postgres', @enabled =1
EXECUTE [msdb].[dbo].[sp_update_job] @job_name='DBA_CDC_InsertLateRecords_DBALog', @enabled =1
EXECUTE [msdb].[dbo].[sp_start_job] N'cdc.GURMEN_capture'
RecordBy
cunay
Record Date
15-02-2012 17:50:50
Düzenle
Kopyala
Sil
