My error is this, I get it when I attempt to take a stored procedure and make it a job. The procedure works on its own. I believe that the error occurs when doing an update using data from a linked Sql server 6.5 DB. How could I correct this?

Here's the error:

"Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query. [SQLSTATE 42000] (Error 7405). The step failed."