Automate running of Stored Procedure each day at midnight

[primagic]

I need to run a stored procedure each day at midnight. I am using shared hosting so I don't have access to SQL Agent or Windows Scheduler.

Is there a way this can be done with either of them?

 

[Qik3Coder]

Do you access to create scheduled jobs?
Just because you don't have access to UI tools, doesn't mean you can't do it programmatically.

Lodlaiden

You've got questions and source code. We want both!
Oh? That? That's not an important password. - IT Security Admin (pw on whiteboard)

 

[primagic]

No I dont have access to scheduled jobs

 

[foxyland]

What about create a trigger page on your web site? The trigger page should be called by other computer (the client), and what it'll do is simply trigger the SP to run.

hth,
foxyland