Microsoft Sql 2012 Jobs

YUSUF TURAN

(@YUSUFTURAN)

Gönderiler: 4

Active Member

Konu başlatıcı

Merhabalar Arkadaşlar,

Microsoft Sql 2012 Standart RunTime Kullanıyorum

Normalde çalışan query'i jobs'a attığımda "Start Job at Step" diyorum denemek için

1. Adım Start Job Başarılı diyor

2.Adım Execute Job Error hatası alıyorum: Execution of job failed. see the history log for details

History Baktığımda ise: Aşağıdaki log mevcut yardımcı olabilirseniz sevinirim

07/08/2014
10:20:00,dene,Error,1,T420,dene,Step,,Executed as user: NT
SERVICE\SQLSERVERAGENT. UPDATE failed because the following SET options
have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options
are correct for use with indexed views and/or indexes on computed
columns and/or filtered indexes and/or query notifications and/or XML
data type methods and/or spatial index operations. [SQLSTATE 42000]
(Error 1934). The step failed.,00:00:00,16,1934,,,,0

Gönderildi : 08/07/2014 14:09

YUSUF TURAN

(@YUSUFTURAN)

Gönderiler: 4

Active Member

Konu başlatıcı

yeni hata mesajımız:

Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
07/09/2014 08:58:49,dene,Error,,T420,dene,,,The job failed. The Job was invoked by User sa. The last step to run was step 1 (Step).,00:00:00,0,0,,,,0
07/09/2014 08:58:49,dene,Error,1,T420,dene,Step,,Executed as user: NT SERVICE\SQLSERVERAGENT. 'QUOTED_IDENTIFIERS' is not a recognized SET option. [SQLSTATE 42000] (Error 195). The step failed.,00:00:00,15,195,,,,0

çalıştırmak istedigim query:

UPDATE ITM SET ITM.PRODUCERCODE=UNI.BARCODE FROM LG_004_ITEMS ITM , LG_004_UNITBARCODE UNI ,LG_004_ITMUNITA ITA
WHERE ITM.LOGICALREF=UNI.ITEMREF AND ITM.LOGICALREF=ITA.ITEMREF AND ITA.LOGICALREF=UNI.ITMUNITAREF AND ITA.LINENR=1 AND UNI.LINENR=1

UPDATE TNM SET TNM.AMBAR1=ISNULL(GNT.ONHAND,0) FROM LG_XT1001_004 TNM, LV_004_01_GNTOTST GNT WHERE TNM.PARLOGREF=GNT.STOCKREF AND INVENNO=0
UPDATE TNM SET TNM.Ambar2=ISNULL(GNT.ONHAND,0) FROM LG_XT1001_004 TNM, LV_004_01_GNTOTST GNT WHERE TNM.PARLOGREF=GNT.STOCKREF AND INVENNO=1
UPDATE TNM SET TNM.AMBAR3=ISNULL(GNT.ONHAND,0) FROM LG_XT1001_004 TNM, LV_004_01_GNTOTST GNT WHERE TNM.PARLOGREF=GNT.STOCKREF AND INVENNO=2

UPDATE CLC SET SPECODE5 = (SELECT CONVERT(NVARCHAR(11) ,MAX(DATE_),13) FROM LG_004_01_CLFLINE WHERE CLIENTREF=CLC.LOGICALREF AND TRCODE IN (1,20,61))
FROM LG_004_CLCARD CLC

Gönderildi : 09/07/2014 12:01