Relation between subscription and job name SSRS
use ReportServer$NEWTEST
SELECT Schedule.ScheduleID AS SQLAgent_Job_Name, Subscriptions.Description AS sub_desc, Subscriptions.DeliveryExtension AS sub_delExt,[Catalog].Name AS ReportName, [Catalog].Path AS ReportPath
FROM ReportSchedule
INNER JOIN Schedule ON ReportSchedule.ScheduleID = Schedule.ScheduleID
INNER JOIN Subscriptions ON ReportSchedule.SubscriptionID = Subscriptions.SubscriptionID
INNER JOIN [Catalog] ON ReportSchedule.ReportID = [Catalog].ItemID AND Subscriptions.Report_OID = [Catalog].ItemID
How to configure a Report Server for E-mail Delivery (Reporting Services Configuration)
Attention! You should not take directly the information such as "Server name", "Report Server Instance", etc. directly from the screenshot. These are only examples.
Start the Reporting Services Configuration tool and connect to the report server instance.
On the Email Settings page, enter the name of the SMTP server. This value can be an IP address, a UNC name of a computer on your corporate intranet, or a fully qualified domain name.
In Sender Address, enter the name an account that has permission to send e-mail from the SMTP server.
Click Apply.
Comments