How can I execute a stored procedure as a job?

• gary.dunn

  SSC-Addicted

  Points: 412

  More actions

  May 13, 2009 at 8:44 am

  #200392

  Hi, I've created a stored procedure and it works fine. Now I want to run it every day at 6 AM. I'd like to create a job that'll run the sp but I don't know how. Can anyone help me?

  Thanks,

  Gary

• LutzM

  SSC Guru

  Points: 107049

  More actions

  May 13, 2009 at 8:50 am

  #993794

  Did you look up "job steps [Transact-SQL]" in BOL?

  It'll give you a lot information on how to set up a job either using TSQL or Management Studio.

  ---

  
  Lutz
  A pessimist is an optimist with experience.

  How to get fast answers to your question[/url]
  How to post performance related questions[/url]
  Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

• Ken Simmons

  SSCertifiable

  Points: 7822

  More actions

  May 13, 2009 at 9:05 am

  #993807

  I found a link with some instructions and pictures that may help.

  http://www.dailycoding.com/Posts/step_by_step_guide_to_add_a_sql_job_in_sql_server_2005.aspx