Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Posts
    176

    Unanswered: stored procedure

    I have a stored procedure to get the data from table1 and writes into table2 with some formatting.Table1 will be changing daily and the data in table2 also should get changed.for that,my stored procedure has to run for every mnute .How to make my stored procedure to run all the time...
    Thanks

  2. #2
    Join Date
    Feb 2003
    Location
    Montreal, Canada
    Posts
    117

    Re: stored procedure

    Define a job, include your SP in that job and then schedule the job to run at every 1 min.


    Originally posted by bruce_Reid
    I have a stored procedure to get the data from table1 and writes into table2 with some formatting.Table1 will be changing daily and the data in table2 also should get changed.for that,my stored procedure has to run for every mnute .How to make my stored procedure to run all the time...
    Thanks
    Steve

  3. #3
    Join Date
    Apr 2003
    Posts
    176
    k,thsnk you.I got the process

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •