Hi,
When my database opens I have it set up to run a bunch or queries, format, generate, and save output as excel files. Can I set this to run automatically at night? If yes how would I do this?
Thanks
Virginia
It depends on the platform the database is running. If the database is on a server you could have the server execute a task which starts your database, on opening the database will execute the functions above. If the database is on a Windows workstation you could use Taskmanager to execute the database, for this the workstation will have to be powered on.
Bottom line; autostarting the database will have to be a task run by the platform (server, workstation) the database is on.
Sander