Post reply

Can I have a SQL Agent Job which runs a report, then a process, then another report?

  • December 1, 2011 at 1:25 pm

    #248934

    All,

    Is it possible to invoke SQL Agent Job which executes a reporting service report to email the outcome to users, then executes a stored procedure, then executes another reporting service report to email the outcome to users?

    It seems doable - I cannot find an example of the necessary syntax.

    What we are trying to uncover here is if a process is creating orphan records - so we'd report on any existing orphans, run the process, then rerun the report on orphans to see if more have been created.

    Thoughts?

    Thanks,

    SQLOzzie

  • December 1, 2011 at 1:29 pm

    #1415545

    In short, YES ... http://www.sqlservercentral.com/articles/Development/2824/

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg

  • December 1, 2011 at 2:22 pm

    #1415594

    Most excellent response.

    Doug

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply