CODEWITHSUNDEEP
sqlsql-servert-sqlsql-server-2008sql-server-agent
George2
George2

Reputation: 45771

How do I execute a stored procedure in a SQL Agent job?

I am using SQL Server 2008 and I need to run a SQL Job from SQL Server Agent. I am new to SQL Server Job and I want to execute a stored procedure regularly from a SQL Server Job. But I did not find where to specify the executed stored procedure other than copy & paste SQL commands.

Here is my screen snapshot:

enter image description here

Any ideas how to assign stored procedure to execute in SQL Server Job?

Upvotes: 44

Views: 138395

Answers (2)

marc_s
marc_s

Reputation: 754268

You just need to add this line to the window there:

exec (your stored proc name) (and possibly add parameters)

What is your stored proc called, and what parameters does it expect?

Upvotes: 76

Dan Diplo
Dan Diplo

Reputation: 25339

As Marc says, you run it exactly like you would from the command line. See Creating SQL Server Agent Jobs on MSDN.

Upvotes: 3

Related Questions