log_shipping_monitor_alert (Transact-SQL)


Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

Column nameData typeDescription
alert_job_iduniqueidentifierThe SQL Server Agent job ID of the log shipping alert job.

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)

Community Additions