Vinay Jain
Reputation: 2634
automatic events occured on time in SQL ASP.net
i am developing a website and in this i want automatic SQL procedure call that will called after every 15 days...
is there any trigger or procedure that works for it or in ASP.net or vb.net to achieve the above task...
thanks in advance...
Upvotes: 0
Views: 91
Answers (1)
Kevin Ross
Reputation: 7215
If you are using a full (I.e. not express) version of SQL server then just use the SQL agent to schedule a job. If you are using an express edition then you can get around it by using the windows scheduler to run a batch file that fires your stored procedure
Upvotes: 2
Related Questions
- How can I set an event using the data from a SQL database
- Time Based Events in ASP.net
- How to perform an action on a database on certain times
- Drop the table Or Delete all data, and how do events based on time on server
- Triggering an event on specific days and times
- Solution to a timed out/End Date event
- Auto excute SQL query after a fixed time in ASP.NET
- Best approach to Triggering Event on SQL database
- Event generation in database based on time
- The best way of triggering a timely event