1

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

2 Answers 2

1

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.

0

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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .