Pro Members, SQL Server, Standard Members

Undocumented SQL Server 2017 job stored procedures

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 – Valentine’s, Pro Member Monthly – Valentine’s, Standard, Standard Member, Standard Member Annual – Valentine’s and Standard Member Monthly – Valentine’s members only.
Log In Register
Facebooktwittergoogle_plusredditpinterestlinkedinmail

Comments are closed.