Skip to content

Latest commit

 

History

History
34 lines (29 loc) · 1.56 KB

log-shipping-monitor-alert-transact-sql.md

File metadata and controls

34 lines (29 loc) · 1.56 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
log_shipping_monitor_alert (Transact-SQL)
log_shipping_monitor_alert (Transact-SQL)
VanMSFT
vanto
06/10/2016
sql
system-objects
reference
log_shipping_monitor_alert
log_shipping_monitor_alert_TSQL
log_shipping_monitor_alert system table
TSQL

log_shipping_monitor_alert (Transact-SQL)

[!INCLUDE SQL Server]

Stores the alert job ID for log shipping. This table is stored in the msdb database.

Column name Data type Description
alert_job_id uniqueidentifier The [!INCLUDEssNoVersion] Agent job ID of the log shipping alert job.

See Also

About Log Shipping (SQL Server)
sp_add_log_shipping_alert_job (Transact-SQL)
sp_delete_log_shipping_alert_job (Transact-SQL)
sp_help_log_shipping_alert_job (Transact-SQL)
System Tables (Transact-SQL)