Browse by Tags

Tagged Content List
  • Blog Post: Get the NULL percentage of values in a specific table dynamically

    Nothing really fancy, but a small script I was now asked twice for. So I thought I publish it for the public and for the reference for others. It simply calculates the percentage of NULL values for a specific table in all columns. The last request was originated from the post here . Be aware that...
  • Blog Post: Script out jobs in SQL Server v2

      For those asking a couple of times if the JobScripter for SQL Server Agent jobs is also available in 2008… here it is ! The only difference is that the version v2 is now targeting to SMO Assemblies of SQL Server 2008 which is version 10.0. This sure means that you are able to pick up the information...
  • Blog Post: Did your SQL Agent doze off and you don´t know which jobs to run afterwards ?

      In some cases you might face the problem that SQL Server Agent Service didn't come up or was stopped for reason. Jobs scheduled in the downtime will not run automatically when the Agent service comes up again, and that is a good thing. I often hear people saying, why isn’t that supposed to be...
  • Blog Post: Script out Jobs in SQL Server

    Do you want to script out the jobs available in SQL Server Agent ? There a many ways to skin the cat. The probably easiest one is to us the built in functionality of SSMS. Simply select all the jobs (doing a STRG+A on the Object Explorer list) and choose Script. Script jobs separately...
  • Blog Post: Determine the current status of a SQL Server Agent job

    Due to the problem that there is no definite table for getting information about the current status of jobs, I created a small procedure grabbing the information from parts of the internal procedures used to extract the very relevant information. As an (optional) parameter you can specify a jobname you...
Page 1 of 1 (5 items)