Other News

Editorials

What Does it Take to Recover the World?

This webcast is today – I’ll be the host. Will you join us? Facing a System Rebuild? There have been a few times in life when I’ve had to go through rebuilding the world – re-creating a server from scratch due to a system failure. It wasn’t much fun, and it was painful. You have different backups in different places, […]

Editorials

My First 30 Days

I thought I would take the first thirty days challenge myself as something to throw darts at. I am confident in what I do; but, always open to suggestions for improvement from others. The actual tasks I would do would depend on resources available to me in the form of documentation, people and budget. I would start addressing issues in […]

Pro Members SQL Server Standard Members

Useful undocumented SQL Server 2012 Agent Procedures

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