Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Skydolphin
Starting Member
43 Posts |
 Posted - 2009-10-30 : 16:10:15
|
| Can someone point me in the direction of how I would go about creating a job to send out a status notification? I would like it to include things like how many records have been processed, how many times a certain job successfully ran, etc. I am not sure how to begin.Thanks,Rhonda |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Skydolphin
Starting Member
43 Posts |
Posted - 2009-11-03 : 18:32:30
|
| OK that kind gives me an idea where to begin. Does anyone happen to have any examples? I really don't know how to go about doing this and searches aren't really coming up with any help. Perhaps I'm not searching on the correct thing.Thanks,RhondaRhonda |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Skydolphin
Starting Member
43 Posts |
Posted - 2009-11-04 : 12:52:28
|
| I guess I'm not really being clear. The sending of the mail part is not the part I am concerned about. I'm more concerned about not really knowing how to go about gathering the statistics that I need. Are there any system stored procedures to do it or do I have to write something from scratch?ThanksRhonda |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Job to report status