Solved

executing Sql server strored proc at a given time

Posted on 2008-10-15
7
148 Views
Last Modified: 2010-03-19
Hello,
How can i execute a Sql server 2005 stored procedure called sp11 every wednesday @ 9h45 AM.

thanks a lot
0
Comment
Question by:Nyana22
7 Comments
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 22722143
Schedule it as a job through SQL Server agent in Management studio.
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 22722158
to expand upon that: SQL Server Agent will appear when you expand the servername in the object explorer.  Expand SQL Server Agent, right click Jobs, new job.
0
 

Author Comment

by:Nyana22
ID: 22722170
thanks, but how?
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 60

Assisted Solution

by:chapmandew
chapmandew earned 40 total points
ID: 22722189
0
 

Author Comment

by:Nyana22
ID: 22722242
i didnt find it, is it because i have the express version??
0
 
LVL 2

Assisted Solution

by:tree33
tree33 earned 60 total points
ID: 22722272
You can not schedule Jobs in the Express edition using a SQL Agent.
Another way whould be to create a osql script and the schedule this using the Windows Task Scheduler.
http://msdn.microsoft.com/en-us/library/aa213090(SQL.80).aspx
0
 
LVL 39

Accepted Solution

by:
BrandonGalderisi earned 200 total points
ID: 22722280
Yes.  SQL Server express does not have SQL Server agent.

There are a lot of things you can do and articles to read:

http://www.sqlteam.com/article/scheduling-jobs-in-sql-server-express

The other thing you can do is just create a Windows Scheduler job to execute it with sqlcmd.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question