Running SQL Server 2008 R2 - on - Windows Server 2008 R2 - 64 bit
Access 2003 application running on a different server (Server1) - linked
There are several scheduled tasks on Server1 - one is a UPS delivery tracking executable, others open Access apps (linked to SQL) which kick off the Autoexec -- run some queries -- and close.
For some reason after they reboot the SQL Server the Scheduled Events on Server1 set for 3:00 AM the following morning -- they appear to have run -- but the queries do not appear to have run -- as the data is not updated.
My Question is this: Is it possible that after a SQL Server reboot that somehow these Access applications lose their links to the SQL Server -- connected via ODBC -- because when they are invoked via the scheduled tasks -- they do not appear to do what they're supposed to.
I'm really lost as to why these tasks suddenly stop working on a server that is not being rebooted so the only thing I can think of is that somehow these links are lost??
Any help will be appreciated. Thanks so much!!