Sign In
Microsoft SQL Server Agent Team Blog
The writers of this blog are a part of the Microsoft SQL Server Agent team. We will be blogging about our tools, scripts, webcasts, and miscellaneous tips that will help you get the most out of SQL Agent, Database Mail, Data collector.
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Common Tasks
Blog Home
Email Blog Author
OK
RSS for comments
RSS for posts
Atom
Subscribe via RSS
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Tags
Data Collector
Database Mail
Powershell
quoted_identifier
Scheduler
SQL Agent
Sql Agent History
SQL Azure
SQL Server Agent
XEvent
Monthly Archives
Archives
January 2012
(1)
November 2011
(2)
July 2011
(4)
June 2011
(1)
April 2011
(2)
March 2011
(2)
February 2011
(3)
January 2011
(6)
December 2010
(2)
November 2010
(8)
October 2010
(6)
September 2010
(2)
MSDN Blogs
>
Microsoft SQL Server Agent Team Blog
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Microsoft SQL Server Agent Team Blog
FIX: SSMS : Can no longer create or edit job steps - Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed
Posted
23 days ago
by
Sethu Srinivasan
0
Comments
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...
Microsoft SQL Server Agent Team Blog
Gathering failed job history using power shell
Posted
3 months ago
by
Sethu Srinivasan
0
Comments
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...
Microsoft SQL Server Agent Team Blog
Automatic backups, one per day, and with different backup file names
Posted
3 months ago
by
Sethu Srinivasan
0
Comments
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...
Microsoft SQL Server Agent Team Blog
Using a stop event in CMDEXEC subsystem
Posted
6 months ago
by
tibid
0
Comments
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....
Microsoft SQL Server Agent Team Blog
Remove associated data collector jobs
Posted
6 months ago
by
Sethu Srinivasan
6
Comments
**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...
Microsoft SQL Server Agent Team Blog
Enabling additional tracing for data collector
Posted
7 months ago
by
Sethu Srinivasan
0
Comments
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...
Microsoft SQL Server Agent Team Blog
Email Query output as ANSI / UNICODE file attachment using Powershell and Database Mail
Posted
7 months ago
by
Sethu Srinivasan
1
Comments
#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...
Microsoft SQL Server Agent Team Blog
Backing up a database in a DB Mirroring configuration
Posted
7 months ago
by
Sethu Srinivasan
1
Comments
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...
Microsoft SQL Server Agent Team Blog
Data Collector's sp_purge_data may run for hours if there are many orphaned plans to purge
Posted
10 months ago
by
Sethu Srinivasan
0
Comments
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...
Microsoft SQL Server Agent Team Blog
Auditing changes done to syscollector_execution_log_internal & tracking root cause of Error 14262
Posted
10 months ago
by
Sethu Srinivasan
0
Comments
-- 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...
Microsoft SQL Server Agent Team Blog
Incorporating Extended events (Xevent) default system_health session with the Data collector.
Posted
10 months ago
by
Sethu Srinivasan
2
Comments
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
Microsoft SQL Server Agent Team Blog
Please help us to build SQL Agent on SQL Azure
Posted
11 months ago
by
Jasamba
0
Comments
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 ...
Microsoft SQL Server Agent Team Blog
More Scheduling Tips And Tricks–StartTime and EndTime
Posted
11 months ago
by
tibid
0
Comments
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...
Microsoft SQL Server Agent Team Blog
Auditing SQL Agent job creation and deletion
Posted
11 months ago
by
Sethu Srinivasan
4
Comments
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...
Microsoft SQL Server Agent Team Blog
SQL Database Mail - Security Feature of DatabaseMailUserRole
Posted
over 1 year ago
by
Yuhong Li - MSFT
0
Comments
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...
Microsoft SQL Server Agent Team Blog
Permissions for Job and Schedule Owners
Posted
over 1 year ago
by
tibid
0
Comments
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...
Microsoft SQL Server Agent Team Blog
Scheduling Tips and Tricks
Posted
over 1 year ago
by
tibid
0
Comments
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...
Microsoft SQL Server Agent Team Blog
SQL Database Mail -- Cleanup of Logging Records
Posted
over 1 year ago
by
Yuhong Li - MSFT
1
Comments
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...
Microsoft SQL Server Agent Team Blog
Limit resources used by SQL PowerShell Jobs using Resource Governor
Posted
over 1 year ago
by
Sethu Srinivasan
0
Comments
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...
Microsoft SQL Server Agent Team Blog
Sql Agent Quick Tip- Deleting History
Posted
over 1 year ago
by
Robann Mateja
0
Comments
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...
Microsoft SQL Server Agent Team Blog
SQL Database Mail -- Send Emails in HTML Format
Posted
over 1 year ago
by
Yuhong Li - MSFT
0
Comments
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...
Microsoft SQL Server Agent Team Blog
Starting Jobs in Powershell using Job Name
Posted
over 2 years ago
by
Sethu Srinivasan
3
Comments
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...
Microsoft SQL Server Agent Team Blog
Troubleshooting: SQL Agent can’t start without SQLAGENT.OUT telling the reason
Posted
over 2 years ago
by
Yuhong Li - MSFT
0
Comments
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...
Microsoft SQL Server Agent Team Blog
Enabling email notifications in the SQL Agent for Alerting & Job monitoring
Posted
over 2 years ago
by
Jasamba
0
Comments
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...
Microsoft SQL Server Agent Team Blog
Database Mail–when attachments don’t work
Posted
over 2 years ago
by
tibid
0
Comments
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...
Page 1 of 2 (39 items)
1
2