I was running a SQL query from SQL agent which connects to Netezza using linked server I tested it using mangement studio it worked fine with very little data set ,
When I scheduled using SQL server agent it failed giving this following error.
Executed as user: EUR\ldnfitsqlems04. Cannot fetch a row from OLE DB provider "NZOLEDB" for linked server "NETEZZA_PRODUCTION". [SQLSTATE 42000] (Error 7330) OLE DB provider "NZOLEDB" for linked server "NETEZZA_PRODUCTION" returned message "ERROR:
Query was cancelled. ". [SQLSTATE 01000] (Error 7412). The step failed.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.