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?
 
Lee SavidgeConnect With a Mentor Commented:
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
 
knamcAuthor Commented:
I am very new to MS SQL Server.  Any help is greatly appreciated.
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
How to: Schedule a Job (SQL Server Management Studio)
http://technet.microsoft.com/en-us/library/ms191439.aspx
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
knamcAuthor Commented:
Do I just use the execute command and the procedure name?
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor 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
All Courses

From novice to tech pro — start learning today.