Download RDL file for SSRS report for Maintenance Task

Download RDL file for SSRS report for Maintenance Task. Please download the RDL file and import it to your SSRS server. That is it. You are done. Run the report and be aware of the status of your maintenance tasks weekly or daily.Read the full post from http://anoopcnair.com/2013

 
 
 
 
 
(0)
1,934 times
Add to favorites
System Center
10/22/2013
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


  • last run time and end time is not consistance
    2 Posts | Last post October 22, 2013
    • As per the table SQLTaskStatus, the Backup maintanance task completed within just 3 seconds but as per the log,SMSBKUP.LOG it is around 210 seconds...
    • Yes, True. This won't very accurate however this would be very help for troubleshooting.
  • Errors
    2 Posts | Last post October 22, 2013
    • Imported this into my SCCM 2012 SP1 environment and get an error when running.
      
      Microsoft.Reporting.WinForms.ReportServerException
      An error has occurred during report processing. (rsProcessingAborted)
      
      
      Stack Trace:
         at Microsoft.Reporting.WinForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
         at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)
         at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report)
         at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation()
         at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation()
         at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)
      
    • I've updated the post with possible issues and resolution steps.
      http://anoopcnair.com/2013/10/22/custom-report-check-status-predefined-maintenance-tasks/