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

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

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

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

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

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

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

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

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

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

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

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

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

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