Linked Server and MSSQL Job

• jimbeam10

  SSC Enthusiast

  Points: 190

  More actions

  April 3, 2014 at 5:52 am

  #306050

  Hi, i have a stored procedure which uses the DB2OLEDB driver which i use to connect to an AS400 database. When the MSSQL job calls the Stored Proc i get an error

  The requested operation cannot be performed because OLE DB Provider DB2OLEDB for linked server AS400 does not support the required transaction interface

  but then i tried a part of my code inside the stored procedure which deletes records from the AS400 database, i placed it in the MSSQL Job and it is runs successfully.

  could anyone explain to me why MSSQL job accepts the bare code instead of calling a stored procedure.

  Thanks