Post reply

How to create job and schedule it run on daily basis

  • July 22, 2009 at 6:23 am

    #140021

    Hi all,

    i am using sql server 2005

    How to create job and schedule it run on daily basis.

    here my table run at on daily 1AM then select the records today and above date recordes

    how to create job and schedule and storeprocedure.

    yours

    pols

  • July 22, 2009 at 8:53 am

    #1028373

    You can find step by step instructions for creating a scheduled SQL Agent job in BooksOnLine. The easiest way to do it is to right-click on SQL Server Agent in Management Studio and select new...job. You'll see several pages in the New Job pane, including Steps and Schedules. Put the execution of the stored procedure in a step and create the daily schedule.

    Greg

  • July 22, 2009 at 9:23 am

    #1028407

    you mention running a table, but that doesn't make sense. How do you want to consume this data or store it? What's the point?

  • July 22, 2009 at 9:35 am

    #1028431

    BTW, This is a cross-post. I answered the same question over here:

    http://www.sqlservercentral.com/Forums/Topic757335-145-1.aspx

    Please don't post the same question in multiple locations. It really diffuses the conversation and duplicates effort.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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