ansaurus

Question

how to execute a stored procedure in a SQL Agent job?

Answer 1

+3 A:

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??

Marc

marc_s 2009-08-01 10:00:56

Thanks Marc, my store procedure does not have any parameters. It just does some clean-up work to delete all age out records as I asked in the previous question. In my sample, I just need to enter "exec [dbo].[MyStoreProcedureName]", correct?

George2 2009-08-01 10:03:58

Yep, that would be it.

marc_s 2009-08-01 10:09:59

Database context too: Change the Database to "MyDB" or specify the stored proc as EXEC Mydb.dbo.MyProcname

gbn 2009-08-01 11:01:05

Good point, gbn - the database needs to be correct, too!

marc_s 2009-08-01 11:16:03

Answer 2

+2 A:

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

Dan Diplo 2009-08-01 10:05:18

ansaurus

tags:

views:

answers:

how to execute a stored procedure in a SQL Agent job?

related questions