SQL Job

• Chandru -734144

  Ten Centuries

  Points: 1040

  More actions

  July 10, 2008 at 8:30 am

  #381586

  Dear all.,

  I need your help the thing is i want to create a job for updating a table for every 5 mins can any one help me on this or else give some useful links regarding the Job related examples..

  Thanks

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  July 10, 2008 at 8:44 am

  #840879

  Create the procedure that will update the table,

  Under SQL server Agent in Object Explorer, right-click jobs and click new job...

  follow the setup in here,

  You will need to exec your stored procedure from the steps tab.

  and you can create a schedule under the schedule tab to run every five minutes every day.