How do you schedule a stored Procedure to run daily in SQL Server Agent?

How do you schedule a stored Procedure to run daily in SQL Server Agent?

I have several stored procedures that I need to schedule to run daily, how can I do this?
knamcAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

knamcAuthor Commented:
I am very new to MS SQL Server.  Any help is greatly appreciated.
0
Lee SavidgeCommented:
Hi,

Read this help file in SQL Books online:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/465fb7fc-7622-4252-a178-ea51691c935b.htm

Regards,

Lee
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Guy Hengel [angelIII / a3]Billing EngineerCommented:
How to: Schedule a Job (SQL Server Management Studio)
http://technet.microsoft.com/en-us/library/ms191439.aspx
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.

knamcAuthor Commented:
Do I just use the execute command and the procedure name?
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
yes, in the job step, just put EXEC your_procedure_name,  while setting the correct database ...
0
knamcAuthor Commented:
what do you mean by setting the correct database?
0
knamcAuthor Commented:
Nevermind about the db, thanks
0
knamcAuthor Commented:
Thank you from a neebie!
0
knamcAuthor Commented:
I used the resources above,  but now when I run the stored procedure from the command line I get this error?  DO I need to add connect command as a step?

Microsoft.SqlServer.ConnectionInfo "A transport error has occurred when receiving results from the server."
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
when you run a tsql step in your job, it will be sql server agent that connects for you (for the sql script you put) to the indicated database.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.