sp-delete-log-shipping-alert-job-transact-sql.md

title	sp_delete_log_shipping_alert_job (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sp_delete_log_shipping_alert_job sp_delete_log_shipping_alert_job_TSQL
dev_langs	TSQL
helpviewer_keywords	sp_delete_log_shipping_alert_job
ms.assetid	5d6c7f07-a163-48fa-8c1f-abc252043dde
author	MashaMSFT
ms.author	mathoma

sp_delete_log_shipping_alert_job (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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 Syntax Conventions

Syntax

  
sp_delete_log_shipping_alert_job  
  

Arguments

None.

Return Code Values

0 (success) or 1 (failure)

Result Sets

None.

Remarks

sp_delete_log_shipping_alert_job must be run from the master database on the monitor server.

Permissions

Only members of the sysadmin fixed server role can run this procedure.

Examples

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

About Log Shipping (SQL Server)
System Stored Procedures (Transact-SQL)