In a previous post ( Scheduling Tips and Tricks ) I described how to use TSQL to create a schedule and attach it to an existing job. In this post, I will describe what are the permissions required to create a job/schedule and attach a job to an existing...

In a previous post ( Create a regularly scheduled job ), we described how to create a schedule using the SSMS visual interface. In this post we will touch on issues related to schedules – how to create them in TSQL, how to see if they work as...

Similar to SQL Agent logging history, Database Mail has own logging history. When the logging history is grown too big, you can run T-SQL sysmail_delete_log_sp to clean the logging records. Several examples of using this stored procedure are provided...

Resource governor in SQL Server can be used to limit resource consumption by specific application / user. Long running queries / tasks in SQL PowerShell might consume more SQL server resources. If you would like to set limits, you can do by enabling resource...

This is the first in several posts that will discuss quick tips and tricks for managing Sql Agent history. Today, I'm going to discuss one of the history management options which will let you delete history. There is an easy way to do this, but it has...

Usually the content of emails is sent by Database Mail in a plain text. You can change it to HTML format for a richer content. This article demonstrates how to do it. The article here is assumed that a SQL Database Mail profile "MailProfile1' has been...