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

Cursor Dynamic SQL

By

Today was working on SQL Server cursor standard cursor deification would be like this:...

How to get the Active Directory user password policy values

By

Recently I have had to troubleshoot quite a bit of SQL login issues and...

How do you use PowerShell toc check if an active directory user locked out, disabled etc.?

By

If your organization uses a password policy (there are very good odds these days...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

XP_send mail fail

By ramyours2003

We migrated from sql 2005 to sql 2016  recently in one of the job...

How does DBCC CHECKDB use tempdb?

By RaufDBA

I would like to know the working principle of DBCC regarding the tempdb. I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers