Or,
Have a standard client/daemon such as gstat/gfix/gsec ship with firebird
that when started, it is provided with a config file or command line
specifying the database to use.
In this way, any database could be the master database as long as it has
the appropriate data structures in it.
The data structures could be setup via custom sql ddl commands, which would
also be used to create tasks. In this way, a database including it's
tasks could be defined via an sql script.
I would call it something starting with "f" instead of 'g' as the project
has not been called 'grotten' for years.
Perhaps renaming the other utilities fb_sec, fb_isql, fb_stat, fb_fix,
fb_sched.......
just a thought.
On 29 April 2014 08:32, Carlos H. Cantu <lis...@warmboot.com.br> wrote:
> DY> 29.04.2014 12:09, Mark Rotteveel wrote:
>
> >> If you look at SQL Server, there jobs themselves are not defined for a
> >> specific database (although they may depend on one or more databases).
> >> AFAIK they are stored in the master database. Execution requires an
> Agent
> >> service to be running.
>
> DY> We neither have a master database, nor an agent service, nor database
> DY> links to access user dbs from a master one (or any other solution to
> DY> this issue). Shouldn't we think about something more realistic? Or at
> DY> least postpone scheduled tasks until we have a proper foundation built?
> DY> Dmitry
>
> I'm considering that "master database" would be used only to store the
> jobs information. A client/daemon would read it, create all the
> schedules and run the tasks at desired time (use of OS scheduler is an
> option too). Such "master database" (better call it
> jobs/tasks/scheduler database?) can be created and distributed with
> new installations (like the security2.fdb already is).
>
> If you don't worry about mixing things a bit, maybe even security2.fdb
> could be enhanced to store jobs data, avoiding the need to create a
> new pre-installed database.
>
> []s
> Carlos
> http://www.firebirdnews.org
> FireBase - http://www.FireBase.com.br
>
>
>
>
>
> ------------------------------------------------------------------------------
> "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
> Instantly run your Selenium tests across 300+ browser/OS combos. Get
> unparalleled scalability from the best Selenium testing platform available.
> Simple to use. Nothing to install. Get started now for free."
> http://p.sf.net/sfu/SauceLabs
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos. Get
unparalleled scalability from the best Selenium testing platform available.
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
