sp_delete_log_shipping_alert_job (Transact-SQL)sp_delete_log_shipping_alert_job (Transact-SQL)

适用于: 是SQL Server 否Azure SQL 数据库 否Azure Synapse Analytics (SQL DW) 否并行数据仓库 APPLIES TO: YesSQL Server NoAzure SQL Database NoAzure Synapse Analytics (SQL DW) NoParallel Data Warehouse

如果存在警报作业且不存在其他需要监视的主要和辅助数据库,则从日志传送监视服务器中删除警报作业。Removes an alert job from the log shipping monitor server if the job exists and there are no more primary or secondary databases to be monitored.

主题链接图标 Transact-SQL 语法约定Topic link icon Transact-SQL Syntax Conventions

语法Syntax

  
sp_delete_log_shipping_alert_job  
  

参数Arguments

无。None.

返回代码值Return Code Values

0(成功)或 1(失败)0 (success) or 1 (failure)

结果集Result Sets

无。None.

备注Remarks

必须从监视服务器上的master数据库运行sp_delete_log_shipping_alert_jobsp_delete_log_shipping_alert_job must be run from the master database on the monitor server.

权限Permissions

只有sysadmin固定服务器角色的成员才能运行此过程。Only members of the sysadmin fixed server role can run this procedure.

示例Examples

此示例显示了执行sp_delete_log_shipping_alert_job以删除警报作业。This example shows the execution of sp_delete_log_shipping_alert_job to delete an alert job.

USE master;  
GO  
EXEC sp_delete_log_shipping_alert_job;  

另请参阅See Also

关于日志传送 (SQL Server) About Log Shipping (SQL Server)
系统存储过程 (Transact-SQL)System Stored Procedures (Transact-SQL)