exec sp from sql server agent job?

• Jeff-132889

  Ten Centuries

  Points: 1112

  More actions

  October 4, 2008 at 7:32 pm

  #73052

  I have a sp that runs fine in QA by entering sp_name. I need to run the same sp as a sql server agent job but so far everything I've tried fails.

  EXEC sp_name

  EXEC sp_name;

  Etc.

  Am i getting the syntax wrong here somewhere?

  TIA, Jeff

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  October 4, 2008 at 8:56 pm

  #880880

  What error are you getting?

  Make sure that you have the job step's database set correctly.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]