January 21, 2010 at 8:36 am
can nay one send me the query to find about the full , log and differntial backups of all the databases in a server at what time they scheduled . if they are scheduled through maintainence palns what query needs to be executed to get the scheduling details of all the databases in aserver .
replies are appreciated .
January 21, 2010 at 9:13 am
You can see which jobs are scheduled through the job activity monitor - however if jobs are invoked from stored procedure fairly sure they wouldn't show here - think the only was would be to see what has happen using the system views - Google first hit for me http://www.mssqltips.com/tip.asp?tip=1601
Also the problem in the activity monitor would be if a job performed multiple task, this would not be apparent without viewing the details of the job itself
Hope this helps
January 21, 2010 at 9:34 am
Hi,
If you are specifically looking for a query to run to get the job info...I think you can query MSDB. The tables like sysjobs, sysjobactivity, sysjobsteps, sysschedules etc., hold the jobs information. So, you can filter the info required from these tables....
[font="Verdana"]Renuka__[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply