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

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

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

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

Sql Agent provides tokens to be used with T-Sql job step scripts. Tokens are names (strings) that are replaced at runtime with a value. The tokens provide a feature similar to variables in code. The tokens are described in MSDN ( http://msdn.microsoft...

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

Hello In SQL Agent logs for SQL Server 2012 you may see following message that appears every 90 seconds: "Reloading agent settings". It's indeed painful behavior from the user perspectives, and we will address this issue in nearest Service Pack for...

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

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

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

In SQL 2012, you can use stored proocedure [msdb].dbo] . [sp_syscollector_cleanup_collector] to remove the associated data collector objects that were created while enabling data collector. This stored procedure deletes SQL agent jobs that were created...

You can download SQL 2012 SP1 from http://www.microsoft.com/en-us/download/details.aspx?id=35575 Please send us your feedback / any issues to SQL Server feedback http://connect.microsoft.com/SQLServer/feedback/

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

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

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

If you interested to know more about SQL Agent /DB Mail/ Data Collector or you have a specific questions in regards of your own scenarios or just generic how to questions. Please do not hesitate to ask, leave your question under this blog entry and we...

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

Index rebuild on a large database could take longer time. One of our customer was looking for a solution to rebuild index one by one when index fragmentation is greater than 30%. Related newsgroup thread: http://social.msdn.microsoft.com/Forums/en...

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

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 can use Power shell and SMO to script out objects and its dependents in a database along with object permissions. This blogs entry has a sample power shell script that you can use to generate script in automated way.

Hey Folks Recently we fixed several issues in SQL Agent Scheduler, so if your scheduler is not working as expected probably we have a fix, so how you can make sure that you have latest and greatest. Here the guide SQL Server 2012 RTM has it SQL...

Links for Latest service pack and cumulative updates for SQL Server - http://technet.microsoft.com/en-us/sqlserver/ff803383.aspx

If you see this specific issue while launching SQL Configuration Manager, you can follow the workaround specified in this blog post Workaround: Open Command Windows as Elevated administrator user cd %ProgramFiles(x86)%\Microsoft SQL...