Microsoft SQL Server Front End Blog

The writers of this blog are a part of the Microsoft SQL Server Manageability team. We will be blogging about our tools, scripts, webcasts, and miscellaneous tips that will help you get the most out of SQL Agent, Data collector and other tools

Browse by Tags

Tagged Content List
  • Blog Post: Vote for - Make SQL Server Agent Startup Automatically

    Hello Customers, We received feedback for SQL Agent to set service start up mode as 'Automatic". if you think this is important scenario in your environment, please send us your feedback via https://connect.microsoft.com/SQLServer/feedback/details/912432/make-sql-server-agent-startup-automatically ....
  • Blog Post: Workaround: SQL Server 2012 - OPENROWSET on sp_help_job throws "The metadata could not be determined"

    Issue: In SQL 2012, stored procedures that call any other stored procedures or extended stored procedures that return result sets should specify WITH RESULT SETS SQL Agent's stored procedure sp_help_job - returns single resultset if no parameters are passed to stored procedure. - returns 3 resultsets...
  • Blog Post: FIX: Incomplete Performance Condition alert in SQL Server 2012

    In SQL 2012, there was an issue with output string formatting that missed parameter replacement on the message that was sent as email for performance alerts. We have addressed this fix in SQL 2012 Cumulative update #2. You can download SQL 2012 CU2 from http://support.microsoft.com/kb/2703275/LN ...
  • Blog Post: Create a SQL Agent Job using Managed C++

    You could use the following code sample to create a SQL Agent Job using Managed C++ You can download the sample from MSDN http://code.msdn.microsoft.com/Create-SQL-Agent-job-using-f1ee5004
  • Blog Post: Create SQL Agent job using C# and SMO

    You could use the following code sample to create a SQL Agent Job using C#. You can download the sample from MSDN http://code.msdn.microsoft.com/Create-SQL-Agent-job-using-b95584e7
  • Blog Post: Resetting the Job Step Proxy

    I would like to clarify how to reset a proxy used by specific job. Assuming that I have a job and for the first step of the job I’m using proxy, and the proxy Id = 3 If you want to reset the step proxy back to Null, how you will do it? Some of you may be misled by the article: http://msdn...
  • Blog Post: Automatic backups, one per day, and with different backup file names

    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 about token substitution at http://msdn.microsoft...
  • Blog Post: Backing up a database in a DB Mirroring configuration

    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. On mirrored instance, database backup cannot be performed...
  • Blog Post: Please help us to build SQL Agent on SQL Azure

    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 false EN-US X-NONE X-NONE ...
  • Blog Post: Limit resources used by SQL PowerShell Jobs using Resource Governor

    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 governor, define classifier function to assign...
  • Blog Post: Enabling email notifications in the SQL Agent for Alerting & Job monitoring

    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 Mail - Send Emails from SQL Server". 2. In...
  • Blog Post: Scheduled Policy Evaluation on multiple servers using MSX/ TSX in SQL Agent

    One of our customer was looking for ways to schedule a policy evaluation on multiple servers using their existing MSX/TSX infrastructure. I thought it would be better to blog an article that could help others looking for similar information Before we get into details, here are some basics. Please...
  • Blog Post: SQL Agent Issue with identifiers delimited by double quotation marks

    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" , @Days , GetDate ()) But if you copy and paste...
  • Blog Post: Turning on Verbose logging in SQL Agent

    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, here are the steps you could follow to enable verbose...
  • Blog Post: Creating multi steps SQL Agent job

    I will explain how to add another step to existing job and configure it correctly. Let's assume that you already have a job with 1 step (for example as in Sethu's backup job example ) 1. Open SSMS (SQL Server Management Studio, make sure that SQL Agent is running) navigate to Jobs folder under...
Page 1 of 1 (15 items)