THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server Agent   (RSS)
Showing page 1 of 3 (21 total posts)
  • Do you clean up your Database Mail log tables?

    Database Mail has a couple of log tables in the msdb database. These can become large over time. I've seen MSDB databases over 1 GB in size, where normal size is less than 50 MB (heavy usage of old SSIS deployment model excluded). Unfortunately Maintenance Plans do not have built-in functionality for this, nor does Ola Hallengren's excellent ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on March 5, 2014
  • Wait random number of minutes

    Why on earth would you want to do that? you ask. Say you have a job that is scheduled to start at the same time over a number of servers. This might be because you have an SQL Server Master/Target server environment (MSX/TSX) or you quite simply script a job and execute that script on several servers. You probably want to spread the load on your ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on October 18, 2013
  • Resynchronizing a target server (MSX - TSX)

    I often use SQL Server Agent master / target servers (MSX/TSX). I find it so convenient to create the job once and then just add whatever targetservers (TSX) should have this job. Especially when you later modify the job. Again, just modify it once. The usage of MSX in general, and how I use it, can easily become a series of blog posts in itself. ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on August 11, 2013
  • Express Edition revisited, focus on SSMS

     (Note: I have re-written parts of this post in the light of the comments that SP1 of 2012 include Complete tools.)  I have decided to revisit the topic of whats included in Express Edition, with focus on the tools. I have a couple of reasons for this: In my 2011 post, I never tried to connect from Express SSMS to a non-Express ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on January 30, 2013
  • Backup and the evil RETAINDAYS option

    ''So what bad has this option done?'', you probably as yourself. Well, not much, but I find it evil because it confuses people, especially those new to SQL Server. I have many times seen people specifying something like 3, and expect SQL Server to keep the three most recent backups in the backup file and overwrite everything which is older than ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on July 8, 2012
  • Analyzing the errorlog

    How often do you do this? Look over each message (type) in the errorlog file and determine whether this is something you want to act on. Sure, some (but not all) of you have some monitoring solution in place, but are you 100% confident that it really will notify for all messages that you might find interesting? That there isn't even one little ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on July 5, 2012
  • Two bugs you should be aware of

    In the past 24 hours I have come across two bugs that can be quite problematic in certain environments. LPIM issue with SetFileIoOverlappedRange Last night the CSS team posted a blog entry detailing a potential issue with Lock Pages in Memory and Windows' SetFileIoOverlappedRange API. I tweeted about it at the time, but thought it could use a ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on March 21, 2012
  • Send email after Agent job execution

    After executing a job, I want to have an email with the following information:Success or failure in the mail subject (not just in the body)Success or failure and execution time for each job step in mail bodyHave output file(s) for the job steps attached to emailAgent has none of above built-in so I created my own procedure for this. This is meant ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on December 28, 2011
  • Who owns your jobs?

    Yep, another Agent blog. The topic of job owner has been discussed here before, but this is a specific situation, which potentially is a ticking bomb. First a quick recap of how agent does things: When a job is owned by somebody who is sysadmin, then no impersonation is performed. T-SQL jobsteps will be executed as Agent's own Windows ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on October 6, 2011
  • Agent Alerts Management Pack updated

    I have updated the Agent Alerts Management Pack, cleaned up the T-SQL code which creates the alerts. You can now just copy, paste and execute that code. Earlier, for some of the some of the alert definitions it just generated the calls to the query result window, and you had to copy this to a query window and execute it. Now you just copy the code ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on September 15, 2011
1 2 3 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement