Was this page helpful?

Subscriptions

    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)

    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.

    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
    6059 view(s), 12 edit(s) and 2351 character(s)

    Comments

    You must login to post a comment.