stored procedures didn't execute in last one day?

  • Dear All

    hi

    I have sql server 2005 (enterprise edition) I suppose to know that which stored procedures didn't execute in last one day? through T-SQL statement

    Does somebody have an idea?

    thanx in advance..

  • I am assuming only that you are asking about job execution history?

    http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1148570,00.html

  • [font="Verdana"]Hi,

    Can you provide your exact requirement. You wont be able to track all the proc that is not scheduled as a job, if you need to track those procs either you can run profiler to capture or else you can edit the proc to update a table when its execution gets completed.

    If the proc are scheduled as a job, then you can check the jobhistory to know the status of the proc.[/font]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply