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 » Agent   (RSS)
  • Power Pivot SQL Agent Job Monitor

    In the last days I needed a quick and efficient way to monitor the performance of a job and of each step over time. There’s a lot of interesting data in MSDB database and the various sysjob tables, but the stored data is not really easy to use outside the Management Studio. Date and Time are not stored as date/time data type, there is no easy way ...
    Posted to Davide Mauri (Weblog) by manowar on January 7, 2013
  • Start a SQL Server Agent Job using the SQL Server PowerShell Provider

    Whew!  That’s a mouthfull. Anyway, I thought I would share part of a script I wrote today to help automate (more) from PowerShell. This assumes a few things: that you’re doing this from the SQL Server 2008 PowerShell provider (not just good old regular PowerShell) and that you change the HAL9000 and SQL2K8 parts with your server name and your ...
    Posted to Buck Woody (Weblog) by BuckWoody on February 10, 2010
  • Tools and Processes for “Fitting it all in”

    Most data professionals I’ve met work in two modes: we plan for our day, and we react to the situations around us. I’m staring at my list of things that I need to do today right now, which is my planned work. Of course, I have no idea how much of that will really get done – it’s optimistic to be sure. On the other hand I have several systems I ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 18, 2010
  • Connect Digest : 2009-09-04

    I am heading to my home town for a week; we rented a cottage on Lake Nipissing, and are going to relax.  No, really : no howling beagles, no computers, and no schedule.  Sounds like a week of bliss to me. So, as you might imagine, there won't be a digest next week.  I think I have some interesting items to point out to you this ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on September 4, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement