SQL SERVER-Job中Operators搬迁脚本
标签：code rip res col exec http 技术 UNC inf
SQL SERVER-Job中Operators搬迁脚本
[msdb]
GO
/****** Object: Operator [DB_ITDESK] Script Date: 5/30/2019 9:55:14 AM ******/
EXEC msdb.dbo.sp_add_operator @name=N‘DB_ITDESK‘,
@enabled=1,
@weekday_pager_start_time=80000,
@weekday_pager_end_time=180000,
@saturday_pager_start_time=80000,
@saturday_pager_end_time=180000,
@sunday_pager_start_time=80000,
@sunday_pager_end_time=180000,
@pager_days=127,
@email_address=N‘aa@bb.com‘,
@pager_address=N‘aa@bb.com‘,
@category_name=N‘[Uncategorized]‘,
@netsend_address=N‘172.20.168.121‘
GO