I have an exe in C# in .Net 1.1. This accesses an Oracle database and an SQL Server 2000 database. It is scheduled in SQL Server Agent. It runs for normally 30 seconds and stops
Recently we migrated the database to SQL Server 2005. We created this job manually in SQL Server Agent. Even after running for 3 minutes it never stops (abnormal)
However this exe runs normally in the Windows 2003 scheduler and the command prompt.
Am stumped for an answer.
Any help
Thanks and regards
jarathna
Do have relevant oracle client drivers installed on this SQL 2005 instance?
Ibelieve this is something related to the Operating system related process, if this is scheduled via SQLagent job then ensure SQLserver serivces do have relevant privileges on that C# & Oracle based components share.
No comments:
Post a Comment