[RESOLVED] Run a batch process daily on Godaddy shared hosting
We recently moved over to godaddy shared hosting and have a .net site running. Before we had a process running that would just call a stored procedure and send messages in the system. The problem is GoDaddy doesn't have anything (at least they are not telling me if they do) that would allow me to set something up to run every day at say 4am.
I could do a .exe or just call a web page and have it run the process.
Is there a free online site that would call a webpage daily?
Thanks for any advice.
Re: Run a batch process daily on Godaddy shared hosting
Quote:
Originally Posted by
lleemon
We recently moved over to godaddy shared hosting and have a .net site running...
What would that mean? I don't suppose GoDaddy is hosting your database, or is it?
Re: Run a batch process daily on Godaddy shared hosting
Yes, it does host the SQL Server database.
Re: Run a batch process daily on Godaddy shared hosting
But you must have access to that server. If you do then schedule daily/nightly job to execute your sp using SQL Server Agent - I think that would be simplest way.
Re: Run a batch process daily on Godaddy shared hosting
I can access the database via Microsoft SQL Server Management Studio Express. Can I just start SQL Server Agent just for my db only? Do you have any commands that I can run from the query window to start it?
Re: Run a batch process daily on Godaddy shared hosting
Re: Run a batch process daily on Godaddy shared hosting
Thanks but I talked to GoDaddy and that can't be used. I found a solution:
http://www.setcronjob.com/
Thanks to all who assisted.