executing Sql server strored proc at a given time

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

thanks a lot
Nyana22Asked:
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:

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
 
BrandonGalderisiCommented:
Schedule it as a job through SQL Server agent in Management studio.
0
 
BrandonGalderisiCommented:
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
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?
0
 
Nyana22Author Commented:
i didnt find it, is it because i have the express version??
0
 
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.
http://msdn.microsoft.com/en-us/library/aa213090(SQL.80).aspx
0
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.