Query the tables individually, then you should notice the common columns between the three tables

Job_ID & Schedule_ID appear in 4 times, in different tables, this is the linking route between...

Restarting SQL is not a good idea as it flushes it's cache and when it restarts has to build the cache again which makes performance worse (usually)

A good place to...

well, if thats the case then query msdb.dbo.sysjobs, link it to sysjobschedules then link that to sysschedules for the job id.

Is the name of the job the same or the name of the schedule on each server? If so again query the job or schedule tables to get the...

Check the schedule of the job which is running the task.

Otherwise query msdb.dbo.backupset which will help contain the information you need.

Have you checked the path which the DB thinks where the log is, is actually where the log is, or someone hasn't deleted the log?

Do you have any backups for...

Permissions roles etc will all depend on how you want to lock down access to the databases, only you know what the applications are doing to the database so only...

can you dump out the sql, windows and cluster logs into a zip file and attach to the post, might be worth a second (or many) pair of eyes looking...

Can you post some of the values which are in the columns so that we can try and find a solution.

check the executionlog view in the ReportServer database, check windows logs, sql logs etc, but you will be lucky, that error is so generic that it could be literally anything.

You would want to do something like this

SELECT Class, sum(SumofInvoiceValue), sum(SumofCostPrice), Margin

FROM SalesByClass_Three

WHERE (Invoice_Date BETWEEN @startdate AND @enddate)

group by class, margin

Swings and roundabouts on that one, two folders one for xls the other for txt or two loops one for xls the other for txt will provide exactly the same...

I would load the data into a a staging table which can take it all in as a varchar, then perform a conversion from the staging table to the actual...

Please do not cross post, replies here please http://www.sqlservercentral.com/Forums/Topic1364523-148-1.aspx

Interaction will not work in PDF, you could try exporting the MHTML instead as it should act just like the webpage and pass you through the the report server again...