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)

    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)

    Comments

    You must login to post a comment.