SQL Agent

Providing SQL Agent Job Log Data for Developers

  • Article

As a production Database Administrator, I do not want to give Developers direct access to the SQL Server Agent job log especially for servers in the DMZ. Another problem we have is that when there is a lot of log data for a job, the default job log doesn't contain the full log detail and that makes it harder to troubleshoot. Most of all, we are trying not to use a different code set for deployment based on the environment. Basically we want to use the same methods to deploy our jobs to Development, Test and Production.

2013-01-29

1,816 reads

Blogs

VSCode Tips–Remove the Highlighted Line

By

VSCode was making me crazy as I was writing a script. I like a...

Use T-SQL, not the GUI

By

There’s a very good reason to do most of your DBA work using T-SQL,...

Cloud Computing: Myths, Mysteries, Vampires & Vultures - a free seminar to help you learn more about "the cloud".

By

To be honest you probably think that migrating to the cloud sounds great, and...

Read the latest Blogs

Forums

SQL Tamagotchi! Mini-Servers as Database Pets

By Phil Factor

Comments posted to this topic are about the item SQL Tamagotchi! Mini-Servers as Database...

SQL 2014 (or any other versions) Standard - ~Embedded Licensing~

By Warren Peace

Anyone have any insights on how this licensing works and what the "Use Rights"...

SSIS - Adding Columns to existing table and load data

By sunshine

I am working in SSIS (Sql server version 2012) , I have a requirement...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers