Unix Technical Forum

SqlAnywhere and the Windows Task Scheduler

This is a discussion on SqlAnywhere and the Windows Task Scheduler within the Informix forums, part of the Database Server Software category; --> I've got a scheduled task that is supposed to execute a batch file that is supposed to interface with ...


Go Back   Unix Technical Forum > Database Server Software > Informix

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-20-2008, 08:42 AM
Todd
 
Posts: n/a
Default SqlAnywhere and the Windows Task Scheduler

I've got a scheduled task that is supposed to execute a batch file that
is supposed to interface with a SqlAnywhere 5.0 database in order to do
create some CSV files. When I execute the batch files manually they
work fine. But when the task scheduler tries to execute the batch
files, the files don't update. According to the scheduler log, the
tasks are executing successfully, no errors. The extraction utility
that is being invoked by the batch file is reporting that the database
engine is not running. Could it be that the logged on user has an open
and available connection to the database, but the scheduled task (which
is running under a different set of credentials) has no available
connection?

I'm a SQL Server 2000 guy and know nothing about SqlAnywhere. How does
the security process for SqlAnywhere work?

Todd

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 10:33 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com