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

Code from Redgate Streamed

By

I presented a session today at Redgate Streamed and did a number of demos....

Daily Coping–2 Apr 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Learn SSIS and ADF for Free

By

It’s not from SQLServerCentral, though I hope to do more training across the next...

Read the latest Blogs

Forums

https //teespring com/instalift-cream-reviews-uk

By donnahinrichs

<!--more--> Instalift Most women at age 50 and above take care of gain weight...

Job failed

By ramyours2003

We migrated jobs from sql 2012 to sql 2019 , one  of the job...

Nike Air Max 270 React ENG Photon Dust Coming Soon

By stevenrowe98

has just dropped a brand new “Digital Pink” colorway of the Blazer Mid as...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers