sqlserver 添加操作员

USE [msdb]

GO

/****** 对象:  Operator [auctionOperator]    脚本日期: 04/20/2009 09:27:56 ******/

EXEC msdb.dbo.sp_add_operator 

@name=N'auctionOperator', 

@enabled=1, 

@weekday_pager_start_time=90000, 

@weekday_pager_end_time=180000, 

@saturday_pager_start_time=90000, 

@saturday_pager_end_time=180000, 

@sunday_pager_start_time=90000, 

@sunday_pager_end_time=180000, 

@pager_days=0, 

@email_address=N'yinguang@staff.sina.com.cn', 

@pager_address=N'yinguang@staff.sina.com.cn', 

@category_name=N'[Uncategorized]', 

@netsend_address=N'auctionadress'