Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a Maintainance Plans that runs a SQL job that is failing but not giving and logs to see what is happening. I am new to SQL and not sure what this job is doing.

Job T-SQL

SET ARITHABORT ON

SET CONCAT_NULL_YIELDS_NULL ON

SET QUOTED_IDENTIFIER ON

SET ANSI_NULLS ON

SET ANSI_PADDING ON

SET NUMERIC_ROUNDABORT OFF

share|improve this question
add comment

2 Answers

up vote 1 down vote accepted

If you look at the relevant job in SQL Server Agent, edit the step, and then click on advanced - you'll be able to specify a path for a log for the job. After it has next run, it will create a log - and you'll be able to see what it has done, and where it failed. It is a starting point to troubleshooting.

If you are using SQL2005 or later, if you click on Management - Maintenance Plans, you'll be able to double-click on the relevant plan - and get an idea of what it does. Key maintenance jobs including backups, CheckDB consistency checker, transaction log backups (if needed), and re-indexing.

share|improve this answer
add comment

You should check each of these in the Microsoft documentation - for example SET ARITHABORT. One easy way is to search on each SET command in Google.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.