Issue Details (XML | Word | Printable)

Key: CORE-743
Type: New Feature New Feature
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: tectsoft
Votes: 34
Watchers: 23
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Job / Task Scheduler

Created: 06/Mar/06 12:00 AM   Updated: 10/Nov/14 10:42 PM
Component/s: Engine
Affects Version/s: None
Fix Version/s: None

Issue Links:
Duplicate
 
Relate
 

SF_ID: 1444172


 Description  « Hide
SFID: 1444172#
Submitted By: tectsoft

It would be nice if DBA's or DB Owners had the ability
to create/ammend/delete a scheduled task or job for
each database (or server wide).

Including:

# Initiate a task as soon as the engine is started.
# Initiate a task during idle CPU time.
# Create a one off task for execution on a specified
date/time.
# Create Recurring tasks.
# Initiate a task when a user connects/disconnects
from a database.
# Ability to disable/enable tasks.
# Ability to backup a database.

This is a follow on from this proposal on architect
list
(http://groups.yahoo.com/group/Firebird-Architect/message/8304)

rgds

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Sean Leyne added a comment - 25/Apr/14 02:39 AM
The implementation of this feature would require a complex infrastructure (i.e. Server/Database manager) which would a list of registered databases, which be responsible for ensuring that the databases are opened/active on a 24 hour basis. The functionality could then also include features like server health monitoring, health dashboard and/or email notifications.

This would add complexity to the current install/deployment process, which may not be required for all installations.

This should be taken up as a separate module (like Guardian), it should not be considered part of the engine itself.


TIP Group, S.A. (Olivier Mascia) added a comment - 10/Nov/14 10:42 PM
Sounds like database and application servers confusion to me.
Couldn't FB3 plugin architecture be a simple host for such add-on features?