Custom job alert notification

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

USE adventureworks
GO

DECLARE @tableHTML NVARCHAR(max)

SET @tableHTML = N'<table>' + N'<tr><th>Count</th></tr>'
    + CAST((SELECT td=COUNT(*) FROM [Person].[Address] AS a
           FOR
             XML PATH('tr'),
                 TYPE
           ) AS NVARCHAR(MAX)) + '</TABLE>' ;

-- send email
EXEC msdb..sp_send_dbmail @recipients = N'your.email@address',
    @subject = N'Adventureworks - count of address',
    @body = @tableHTML, @body_format = 'HTML'        

    GO

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]
Using XML for formatting is out so we can only use the xp_sendmail procedure detailed here : http://msdn.microsoft.com/en-us/library/aa260697%28v=SQL.80%29.aspx

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

EXEC xp_sendmail @recipients = 'operator@email.com', 
   @query = 'SELECT COUNT(*) FROM [Person].[Address] AS a',
   @subject = 'SQL Server Report',
   @message = 'The [Person].[Address] table count:',
   @attach_results = 'TRUE', @width = 250

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.