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..

  • [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 2 posts - 1 through 2 (of 2 total)

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