asked on

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?

knamc

ASKER

I am very new to MS SQL Server. Any help is greatly appreciated.

ASKER CERTIFIED SOLUTION

Lee

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

knamc

ASKER

Do I just use the execute command and the procedure name?

SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

knamc

ASKER

what do you mean by setting the correct database?

knamc

ASKER

Nevermind about the db, thanks

knamc

ASKER

Thank you from a neebie!

knamc

ASKER

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."

Guy Hengel [angelIII / a3]

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.