#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Posts
    12
    Rep Power
    0

    how to schedule execution of stored procedures daily ?


    First of all can we schedule the excution of stored procedures - something like the schedulers we have to execute certain tasks at regular intervals - the same way.

    IF we can then, how do we do ?
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    6
    Rep Power
    0
    How about creating a sql job and scheduling the job to run every xx mins.

    The sql job can be created via SQL Enterprise Manager -->Management -->SQL Server agent ---> Jobs ---> new ...
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Posts
    12
    Rep Power
    0
    thank you. Shall try this out.

IMN logo majestic logo threadwatch logo seochat tools logo