Was this page helpful?


    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

    PrtScr capture_4.jpg

    How to configure a Report Server for E-mail Delivery (Reporting Services Configuration)

    Start the Reporting Services Configuration tool and connect to the report server instance.

    PrtScr capture.jpg

    PrtScr capture_2.jpg

    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.

    PrtScr capture_3.jpg

    In Sender Address, enter the name an account that has permission to send e-mail from the SMTP server.

    Click Apply.


    Was this page helpful?
    Tag page (Edit tags)
    • No tags
    Pages that link here
    Page statistics
    5880 view(s), 11 edit(s) and 2112 character(s)


    You must login to post a comment.