Tansact-sql Not Working From Server Agent

I will try to explain this the best I can and even include the code. I have the following:


DECLARE @x XML

SELECT @x =cast(bulkcolumn as XML)

FROM OPENROWSET(BULK 'C:databasexmldtdyahoostore3.xml', SINGLE_BLOB) AS x

USE yahoostore

-- create a table variable

CREATE TABLE PRODUCTS (ProductID VARCHAR(255), Code varchar(255), ProductDesc VARCHAR(255), Url VARCHAR(255),

Orderable varchar(255), Taxable varchar(255), HTMLPath varchar(255),

Caption varchar(255), Thumb varchar(255), Picture varchar(255),

BasePrice varchar(255), LocalizedBasePrice varchar(255), OriginalPrice varchar(255), LocalizedOriginalPrice varchar(255),

SalePrice varchar(255), LocalizedSalePrice varchar(255),

Availability varchar(255), Weight varchar(255), OptionLists varchar(255))



INSERT INTO Products (ProductID, Code, ProductDesc, Url, Orderable, Taxable, HTMLPath,

Caption, Thumb, Picture, BasePrice, LocalizedBasePrice, OriginalPrice, LocalizedOriginalPrice,

SalePrice, LocalizedSalePrice, Availability, Weight, OptionLists)



SELECT

x.value('@Id[1]','varchar(255)') AS id,

x.value('Code[1]', 'VARCHAR(255)') AS code,

x.value('Description[1]','VARCHAR(255)') as description,

x.value('Url[1]','VARCHAR(255)') as url,

x.value('Orderable[1]', 'VARCHAR(255)') AS orderable,

x.value('Taxable[1]', 'VARCHAR(255)') AS taxable,

x.value('Path[1]', 'VARCHAR(255)') as htmlpath,

x.value('Caption[1]', 'VARCHAR(255)') as caption,

x.value('Thumb[1]', 'VARCHAR(255)') AS thumb,

x.value('Picture[1]', 'VARCHAR(255)') AS picture,

x.value('(Pricing/BasePrice)[1]', 'MONEY') AS baseprice,

x.value('(Pricing/LocalizedBasePrice)[1]', 'MONEY') AS localizedbaseprice,

x.value('(Pricing/OriginalPrice)[1]', 'MONEY') AS originalprice,

x.value('(Pricing/LocalizedOrignalPrice)[1]', 'MONEY') AS localizedoriginalprice,

x.value('(Pricing/SalePrice)[1]', 'MONEY') AS saleprice,

x.value('(Pricing/LocalizedSalePrice)[1]', 'MONEY') AS localizedsaleprice,

x.value('Availability[1]', 'VARCHAR(255)') AS availability,

x.value('Weight[1]', 'VARCHAR(255)') AS weight,

x.value('OptionLists[1]', 'VARCHAR(255)') as optionlist





FROM @x.nodes('/StoreExport/Products/Product') s(x)

--SELECT * FROM Products


This workings fine, but when I add it to the server agent to run nightly it fails.

The only thing I see for the error is:
Message
Executed as user: NT AUTHORITYSYSTEM. INSERT 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 query notifications and/or xml data type methods. [SQLSTATE 42000] (Error 1934). The step failed.

Can some one explain what happened and how to fix this
Dee