executing Sql server strored proc at a given time

How can i execute a Sql server 2005 stored procedure called sp11 every wednesday @ 9h45 AM.

thanks a lot
Who is Participating?
BrandonGalderisiConnect With a Mentor Commented:
Yes.  SQL Server express does not have SQL Server agent.

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


The other thing you can do is just create a Windows Scheduler job to execute it with sqlcmd.
Schedule it as a job through SQL Server agent in Management studio.
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.
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Nyana22Author Commented:
thanks, but how?
Nyana22Author Commented:
i didnt find it, is it because i have the express version??
tree33Connect With a Mentor Commented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.