Post reply

How can I execute a stored procedure as a job?

  • 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

  • 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]

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply