Running a daily SQL routine

[Morley]

Is it possible to call a Servoy Method daily from a stored procedure? Here's why I'm asking.

I want an existing, fairly complex method to run daily at midnight across all the records of a Sybase database, whether or not any end users are currently logged in.

This would be easy to create using the Cron scheduler, but apparently this plug-in only functions from Servoy Client. No clients running, the routine doesn't trigger. Five or 50 users currently logged in and the routine runs five or 50 times -- wild overkill and/or possible conflicts.

It's been recommended I get around this plug-in's limitation by using a SQL stored procedure. Crafting native SQL calls is not a comfortable area for me (which is why I'm working within Servoy).

Therefore, can I make a call from a Sybase stored procedure to run a Servoy method daily at midnight?

Kind regards,

[bubba]

Is it possible to call a Servoy Method daily from a stored procedure? Here's why I'm asking.

I want an existing, fairly complex method to run daily at midnight across all the records of a Sybase database, whether or not any end users are currently logged in.

This would be easy to create using the Cron scheduler, but apparently this plug-in only functions from Servoy Client. No clients running, the routine doesn't trigger. Five or 50 users currently logged in and the routine runs five or 50 times -- wild overkill and/or possible conflicts.

It's been recommended I get around this plug-in's limitation by using a SQL stored procedure. Crafting native SQL calls is not a comfortable area for me (which is why I'm working within Servoy).

Therefore, can I make a call from a Sybase stored procedure to run a Servoy method daily at midnight?

Kind regards,

Morely:

I'm not a Sybase guy, but Oracle has the ability to schedule and run stored procs on the server, independent of anything else. I'm pretty sure Sybase has a similar function.

Regards,
Lee Snover

[Morley]

I'm not a Sybase guy, but Oracle has the ability to schedule and run stored procs on the server, independent of anything else. I'm pretty sure Sybase has a similar function.

I'm sure it does. That wasn't really the question.

I already have a routine written in in JS within Servoy and it works. Writing the equivalent again as SQL calls gives me the willies, especially as the routine is fairly involved and includes multiple tables and loops.

I was hoping against hope I could make a call on the existing JS routine. I know that's not likely, but then occasionally there are surprises.

I need this routine to run as a Stored Procedure because Servoy's Scheduler Plug-in works only with Servoy Client. I don't want this routine to run 50 times if 50 clients happen to be open.