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
Register
Already a member? Log in here