数据库

SQL SERVER-Job中Operators搬迁脚本

云博小周宇1 Min Read

选中operators按F7，然后选中对象，生成脚本

USE [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