Tag: sp_get_job_alerts

Pro Members SQL Server Standard Members

Undocumented SQL Server 2017 job stored procedures

by

Undocumented SQL Server 2017 job stored procedures SQL Server 2017 supports the following useful undocumented job stored procedures: sp_MSget_jobstate sp_delete_all_msx_jobs sp_get_job_alerts sp_multi_server_job_summary sp_help_operator_jobs sp_MSget_jobstate The sp_MSget_jobstate stored procedure returns the job state for the specified job. Syntax sp_MSget_jobstate [ @job_id = ] ‘job_id’ Arguments [ @job_id = ] ‘job_id’ Is the job identifier. job_id is UNIQUEIDENTIFIER, with no default. Return...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Useful Undocumented SQL Server 2016 Stored Procedures (Part 4)

by

Useful Undocumented SQL Server 2016 Stored Procedures (Part 4) SQL Server 2016 supports the following useful undocumented stored procedures: sp_check_log_shipping_monitor_alert sp_create_log_shipping_monitor_account sp_log_shipping_get_date_from_file sp_MSget_jobstate sp_get_job_alerts sp_multi_server_job_summary sp_help_operator_jobs sp_check_log_shipping_monitor_alert The sp_check_log_shipping_monitor_alert log shipping stored procedure is used to check all monitor alerts in the primary database and in the secondary database in log shipping configuration. Syntax sp_check_log_shipping_monitor_alert Return Code Values 0 (success)...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
SQL Server

Five Undocumented SQL Server 2014 Job Stored Procedures

by

Five Undocumented SQL Server 2014 Job Stored Procedures SQL Server 2014 supports the following useful undocumented SQL Server job stored procedures: sp_MSget_jobstate sp_delete_all_msx_jobs sp_get_job_alerts sp_multi_server_job_summary sp_help_operator_jobs One of these stored procedures exist in the master database (sp_MSget_jobstate), other exist in the msdb database. sp_MSget_jobstate The sp_MSget_jobstate stored procedure returns the job state for the specified job. Syntax sp_MSget_jobstate [ @job_id […]

Continue Reading →
Pro Members SQL Server Standard Members

Useful undocumented SQL Server 2012 Agent Procedures

by

Useful undocumented SQL Server 2012 Agent Procedures SQL Server 2012 supports the following useful undocumented SQL Server Agent stored procedures: sp_MSgetalertinfo sp_readerrorlog sp_MSget_jobstate sp_delete_all_msx_jobs sp_get_job_alerts sp_multi_server_job_summary sp_help_operator_jobs sp_sqlagent_is_srvrolemember sp_sqlagent_get_startup_info Three of these stored procedures exist in the master database (sp_MSgetalertinfo, sp_readerrorlog and sp_MSget_jobstate), other exist in the msdb database. sp_MSgetalertinfo The sp_MSgetalertinfo stored procedure is used to get information about...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →