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

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

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

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

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

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

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

Database Mail allows you to attach files in emails. Several examples are provided to show how you can do it. The article here is assumed that a SQL Database Mail profile "MailProfile1' has been created. The MailProfile1 tells Database Mail what account...

The issue is related to default settings for quoted_identifier. In SSMS query window the default settings for quoted_identifier is ON. It means that the following code will work: DECLARE @Days INT SELECT @Days = 5 SELECT 'Test' , DateAdd ( "dd...

SQL Server Agent is a Windows service that execute scheduled administrative tasks (Jobs) and notify operators when a specific SQL Server event occurs (Alerts). Jobs: - SQL Server Agent uses SQL Server to store job information. - Jobs contain one or...

When any critical error / warning is reported by SQL Server Agent, it is written to a log file MSSQL\Log\SQLAgent.out. By default only critical errors and warnings are reported to this log file. If you would like to see additional information messages...

Email is so popular now. Do you also want to send emails from database applications by using T-SQL statements? Do you want to send a result of T-SQL queries directly to some one else? If you do, Database Mail is the solution to fulfill your needs. This...