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

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs
sp_help_log_shipping_alert_job (Transact-SQL)	Returns the job ID of the alert job from the log shipping monitor.	MashaMSFT	mathoma	randolphwest	05/14/2024	sql	system-objects	reference	sp_help_log_shipping_alert_job_TSQL sp_help_log_shipping_alert_job	sp_help_log_shipping_alert_job	TSQL

sp_help_log_shipping_alert_job (Transact-SQL)

[!INCLUDE SQL Server]

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

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

sp_help_log_shipping_alert_job
[ ; ]

Arguments

None.

Return code values

0 (success) or 1 (failure).

Result set

This stored procedure returns the [!INCLUDE ssNoVersion] 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.

Related content

• About log shipping (SQL Server)
• System stored procedures (Transact-SQL)