log_shipping_monitor_alert (Transact-SQL)

APPLIES TO: yesSQL Server (starting with 2008) noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

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 SQL Server 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)