• You can see if Data-Driven subscription was successful by viewing Job Activity, Job History, SQL Server & Windows Logs.

    1) Open "MS SQL Server Management Studio" by going to

    Start / Programs / MS SQL 2005 / SQL Server Management Studio and go to SQL Server Agent / right-click "Job Activity Monitor" / View Job Activity / right-click any Job / select "View History"

    2) From "MS SQL Server Management Studio" go to Management / right-click "SQL Server Logs" / select "View" / "SQL Server Log" / check box "Windows NT"

    3) on the Subscriptions tab for report the last "Status" column says something like this "Done: X processed of Y total; Z errors."