log_shipping_monitor_alert (Transact-SQL)

Applies to: 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 SQL Server Agent job ID of the log shipping alert job.

Related content

• About log shipping (SQL Server)
• sys.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)