SQL Server Agent

External Article

Setting Up Your SQL Server Agent Correctly

  • Article

It is important to set up SQL Server Agent Security on the principles of 'executing with minimum privileges’, and ensure that errors are properly logged and alerts are set up for a comprehensive range of errors. SQL Server Agent allows fine-grained control of every job step that should allow tasks to be run entirely safely even if they occasionally need special privileges.

2014-06-13

3,563 reads

Technical Article

Querying SQL Server Agent Job History Data

  • Article

Often times we are tasked with having to programmatically come with a list of durations per SQL Server Agent Job to trend the run times and order the results by date. Unfortunately it's not always easy in the way the data is stored in the system tables in the MSDB database. This tip explains how to use the system tables to get the data into the correct format for dates and job durations.

2013-01-02

3,890 reads

External Article

SQL Server Agent Jobs without an Operator

  • Article

I work in a fairly large and unwieldy SQL Server shop. Our environment is the wild west. I have DBAs and Developers on my team that create SQL Server Agent Jobs all of the time and there is never an operator setup to email anyone based on a failure condition. I know the right solution here is to "tame the wild west" by locking down the environment and setting up a change management process, but I think that is a topic for another day. Can you give me some idea of how to identify the new recently created SQL Server Agent Jobs and Jobs without an operator setup to email us for a failure condition? I would like to receive emails when either of these conditions occur. Check out the solution to this tip to learn how.

2011-06-03

4,386 reads

Blogs

Checking if a database has a master key–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Join me in Germany in June

By

I have been selected to speak at the DataGrillen conference later this year. I will be...

Daily Coping 26 Jan 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

QQ regarding DB_ID()

By YSLGuru

What actions aside from deleting and restoring from backup, would cause the value of...

Restore autmomation

By ramyours2003

i need to  create sql job  which perform automate restore of the databases  with...

Stored Procedure error log integration with APM tools

By stevetb

Hi all, We typically consolidate our logging in an APM tool (eg: like Datadog)....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers