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