the job names and step names are so encripted, they often look like
4DC18F43-DF2F-4F12-BAFB-58DD054EF0BA
or
exec ReportServer.dbo.AddEvent @EventType='TimedSubscription',
@EventData='4ade808a-0199-4

is there an easy way to find out a report name the job is referring
from sql side?
thank you.

It IS is complete PAIN - but i'm not aware of any ways yet to resolve it.
I'll watch your post with interest incase someone knows of a solution, but
i'm not holding my breath!

Show quoteHide quote

Run the following in the ReportServer:

select rs.ScheduleID, c.Path, c.Name
from ReportSchedule rs
    inner join Catalog c on c.ItemID = rs.ReportID


Show quoteHide quote

thanks for the reply.
i know there is a sp you can run to return report name by submitting
job id.
but i'm looking for an 'easy' way to manage them. if there were
hundreds of reports, are we going to query each time just try to find
out which reports have problem?! i tried to add comment in the job but
they got wiped out everytime when the report on the reporting services
being modified and saved.

although MS recommended managing reports thru Reporting Service
Manager, but for testing, it's easier and more flexible to do in the EM
job management. There should be a friendly name in the job properties!

Urgent: Help on query
User-defined Select list
Parse Text Problem
bulk insert from remote machine fails
Copy SQL ResultSet to Variable