October 13, 2010 at 9:54 am
I am very new to SSRS and want to attempt something that I think sounds easy but I don't know how to do. I want to collect information in a table: Server name, start time and end time of a common job. I then want to chart the information on a 24-hr grid that is server and time of day. Each line should show the server name then I would like to see a bar filling in the area between the start time and end time. This would help me greatly with seeing the overlapping of the jobs running. Please help
October 13, 2010 at 12:52 pm
See if the following help:
Report format:
http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/Santa+gets+an+RDL+present/61782/
Getting information from msdb about the jobs
http://www.sqlservercentral.com/articles/SQL+Server+Agent/67726/
http://www.sqlservercentral.com/articles/SQL+Agent/67815/
Russel Loski, MCSE Business Intelligence, Data Platform
October 13, 2010 at 3:23 pm
Russel,
Thank you very much. Your links lokk like exactly what I was looking for. As usual I have been handed an assignment that tie me up for the next 1 to weeks. So I won't be able to get right to this but i don't forsee any problems. Thank you again.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply