I have set up a sample job which is
Then I get alert message on netsend with the job run status.
Is there any way I get the no of records i.e. output of select statement above also in the alert message?
This is a bit more than you probably need but it illustrates the flexibility that Kev mentions. Create a job with a TSL step, paste this in and add your email address. Providing you have an adventureworks database and SQL 2005 or higher you should get an email sent to you with the count that you need
When you start to use TSQL rather than netsend you get much more options. This example is a variation on the example in Books OnLine.
[Edit - following advice that we are working with SQL 2000]
You need Outlook installed on the server and an Outlook Profile created for the account that is running SQL Server service. Then you can write a step that does something like
Hope this is what you need, or close enough to get you there ...
Not with netsend as it is 'out-of-the-box' - you'll have a lot more options available to you if you decided to use email instead.
The other option would be to have a final step in the job that then executes a script to netsend you with whatever message you wanted.
answered Jun 14 '10 at 05:25 AM
Kev Riley ♦♦