Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: Counting stored procedure execution

    I am looking for a way to count the number of times a stored procedure on the database has been executed over let's say over a period of time(month, years, etc).

    Is there a system stored procedure or a system table that stores that information.

    I am struggling to find some information about this topic
    Thanks for the help

  2. #2
    Join Date
    Mar 2004

    Re: Counting stored procedure execution

    I don't know if that information is stored, but what you can do is to create your own table that will store the datetime the stored-procedure is run. You can then run your queries on that table.

    Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!

    Or try our Ask An Expert service to answer any of your questions!

Posting Permissions

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