locked
Automate process thru Notification Services RRS feed

  • Question

  • Task:

    I need to run a stored procedure which creates a view. This is a weekly performance report which i need to send this to my manager every week. As it is a routine process i would like to automate this process. Is it possible that by using notification services of sql 2005 or 2000, every week this view or a report is send to my manager thru email. The stored procedure is not at all required to modify every week because it is based on current date.

    All suggestions welcome.

    Thanks,

    Tuesday, February 27, 2007 4:22 PM

Answers

  • SSNS could be used to accomplish this, but perhaps a better tool in this case would be schedule a job to run the report and notify your manager upon completion (setting him up as an operator).

    HTH...

    Joe


    Wednesday, February 28, 2007 6:56 PM

All replies

  • SSNS could be used to accomplish this, but perhaps a better tool in this case would be schedule a job to run the report and notify your manager upon completion (setting him up as an operator).

    HTH...

    Joe


    Wednesday, February 28, 2007 6:56 PM
  • Thanks a lot.
    Wednesday, February 28, 2007 7:21 PM