If you are satisfied with being notified when the job fails you can schedule
the package then add a fail notification in the job (not package) itself
--
Ray Higdon MCSE, MCDBA, CCNA
---
<anonymous (AT) discussions (DOT) microsoft.com> wrote
Quote:
Hi
Can anyone help me with this please.
I have created DTS package for cubes to be refreshed. I
have sheduled my package to run weekly. I have a
question if my processing fails how I would be notified.
Do I have to create a job. How do I create that Job. If
some one can please let me know with Food Mart Example
that will be great.
Thanks
Steve |