Wednesday, March 21, 2012

How many Jobs ran on a particular database yesterday

How to know how many Jobs ran on a particular database yesterday '
Thanks in Advance
Rajesh.Hi,
See msdb..sysjobhistory and sysjobs table in MSDB database of the server
Thanks
Hari
SQL Server MVP
"Rajesh" <Rajesh@.discussions.microsoft.com> wrote in message
news:5440189B-0811-4A85-84F0-DC7A06002A51@.microsoft.com...
> How to know how many Jobs ran on a particular database yesterday '
> Thanks in Advance
> Rajesh.
>

No comments:

Post a Comment