Post reply

How to create job and schedule it run on daily basis

  • July 22, 2009 at 6:06 am

    #99786

    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 6:17 am

    #1028239

    You need to use the SQL Agent. It's right there in Management Studio. It runs as a service on the machine with SQL Server. Right click on the Jobs folder under SQL Agent and select New Job. You'll probably want to read up on all the details from there in Books Online.

    "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 2 posts - 1 through 1 (of 1 total)

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