those set options are connection specific; they are not server wide.
just because you set it someplace, does not mean it's going to affect jobs or anything else on the server.
each job would need to be edited to have new set options.
if you are connecting with , say .NET, you need to set the options there.
SSMS has a place where you can change most of those settings via the GUI , and every ODBC driver has the ability to set them as well.
Note that even if you could set these items server wide, they would be over-riden by the connections settings themselves.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!