SQL Server Performance

Scheduling a query

Discussion in 'Performance Tuning for DBAs' started by Sri316, Apr 13, 2005.

  1. Sri316 New Member

    Hi all
    Is it possible to schedule a query to run every 5 mins say?? If so please let me know how to acheive it.

    Regds
    Sri
  2. mmarovic Active Member

    Use SQL Server agent. Find it in EM under management folder.
  3. satya Moderator

    ... and ensure to note the execution time of that query, otherwise it may end up in locking the table when 2 similar queries running.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page