TechNet
Export (0) Print
Expand All

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

ADD
Show:
© 2016 Microsoft