Our customers reported issue while launching Job step dialog on SQL 2008 R2 's Management Studio. Here is the related connection issue http://connect.microsoft.com/SQLServer/feedback/details/557402/ssms-can-no-longer-create-or-edit-job-steps Issue...

How to use this powershell script: - Launch SQL Server PowerShell ( Start -> Run -> sqlps.exe) - Copy the following powershell script and save to file (Ex c:\JobHistory.ps1) - in SQL powershell window, type in script file path ( Ex: c:\JobHistory...

SQL Agent can be used to perform scheduled backup job to backup a database to a unique file name that is constructed based on the system date. To construct a unique file name, you can use SQL Agent’s token substitution mechanism. You can read more...

One of the flags that can be specified for a Sql Agent jobstep is 64 (stop event flag). See the article http://msdn.microsoft.com/en-gb/library/ms187358(v=SQL.110).aspx (in the @flags section). This flag is only allowed for CMDEXEC subsystem jobstep....

**NOTE**Please use this script only for testing purpose on TEST systems. T-SQL script in this blog entry can be used to remove the associated data collector objects that were created while enabling data collector. http://connect.microsoft.com/SQLServer...

Note: Please use this only when you see failures in data collector tasks and would like to see more details on the root cause. It is recommended to disable this trace settings after you are done with gathering trace logs 1) Create a folder c:\temp...

#launch sqlps.exe to run the followign script #update servername,email profile, recipient list that matches your environment $instanceName = "MACHINE\SQLINSTANCE" $targetFileAnsi = "c:\temp\result_ansi.csv" $targetFileUnicode = "c:\temp\result_unicode...

Background: Database Mirroring in SQL Server is used to increase database availability. You can read more about database mirroring at http://msdn.microsoft.com/en-us/library/ms189852.aspx . Database can be backed up only on the primary instance...

Here is the fix for data collector purge job taking too long to complete. Please let us know if this fix solves your problem. Please send us your feedback to sethu.srinivasan@microsoft.com . I have also attached the query as attachment to this blog entry...

-- If you are not seeing random failures in following data collection job -- collection_set_1_noncached_collect_and_upload , please ignore this blog entry -- -- This script is to help our dev team understand the root cause of failed data collector job...

Raoul Illyes describes how to create a DC collection set to retrieve and store deadlock information from the system_health XEvent session http://guide-line.com/archives/216#more-216

Please help us in building our next version, If you think that SQL Agent is a nice tool and you want us to continue to develop and support it, please vote for our feature on Normal 0 false false ...

When creating recurring schedules with intra-day parts, StartTime and EndTime define the execution window. Despite the confusing names, StartTime and EndTime have nothing to do with StartDate and EndDate for a schedule. StartTime and EndTime define...

Auditing can be used to track and log events that occur on system. You can read more about auditing here . SQL Agent jobs are added / removed using stored procedure interface sp_add_job and sp_delete_job. Customers have asked us how we could track user...

To prevent anyone from sending arbitrary emails, Database Mail is guarded by the database role DatabaseMailUserRole. Users who are not the member of DatabaseMailUserRole cannot send emails except sysadmin who has all privileges. For example, an unauthorized...

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...

When starting jobs in powershell with smo, you have to use the jobname and categoryID. If you have same job name on multiple servers that could be in different category, and if you are running a single script that connects to multiple servers and starts...

SQLAGENT.OUT, the log file for SQL Agent, is usually the first place to investigate what could go wrong. However, when SQL Agent cannot start, a new SQLAGENT.OUT even is not generated at all. What should we investigate? If this kind of things happens...

To enable email notifications in SQL Agent you will need to follow the following steps: 1. Configure Datbase Mail: create an email SMTP account and corresponding Email Profile. To do so please follow directions outlined in the blog post: "SQL Database...

In a previous post ( SQL Database Mail - Send Emails with Attachment ), we described how to attach a file to an email. There is a known bug related to this. Under certain conditions, the mail attachment will not be sent. If a mail with an attachment...