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

title	sp_help_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_help_log_shipping_alert_job_TSQL sp_help_log_shipping_alert_job
dev_langs	TSQL
helpviewer_keywords	sp_help_log_shipping_alert_job
ms.assetid	4d4b4577-c393-4961-b2d3-b56e980b787b
author	MashaMSFT
ms.author	mathoma

sp_help_log_shipping_alert_job (Transact-SQL)

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

This stored procedure returns the job ID of the alert job from the log shipping monitor.

Transact-SQL Syntax Conventions

Syntax

  
sp_help_log_shipping_alert_job  
  

Arguments

None

Return Code Values

0 (success) or 1 (failure)

Result Sets

This stored procedure returns the [!INCLUDEmsCoName] [!INCLUDEssNoVersion] Agent job ID of the log shipping alert job. If no log shipping alert job exists, it returns an empty result set.

Remarks

sp_help_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.

See Also

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