Scheduled stored procedure

[eDreams]

Since Jodohost doesn't offer scheduling of stored procedures, is there anyone who knows of a good way to circumvent this?

 

[skypanther]

Could you build a web page that calls your stored procedure and then schedule the loading of that page using cron, Windows Task Scheduler, etc.?

Tim

 

[Stephen]

You can also make a page on the site call a page that runs the SP, so visitors trigger the SP.

 

[eDreams]

The stored proc is supposed to run once, per day. Takes about two minutes to run through it all, so trigging it on pages won't be that handy.

What skypanther said though .. That'll work. Too bad Windows servers can't use Task Scheduler through HSPHERE

 

[eDreams]

Since it takes the proc about 2 minutes to get done, anyone know of a way to have the page NOT time out?

 

[eDreams]

Never mind. Apparently the proc goes through anyway - even if the page times out before it's been finished.