Custom job alert notification

• SPAREUS

  SSC Rookie

  Points: 48

  More actions

  June 14, 2010 at 2:00 am

  #233731

  I have set up a sampel job which is select count(*) from [SR]

  It will give no of records in table SR as say 120.

  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?

  Regards,

  Spareus

• gsc_dba

  SSCertifiable

  Points: 5407

  More actions

  June 15, 2010 at 5:24 am

  #1180319

  DECLARE @countnotification INT

  SELECT @countnotification = COUNT(*)

  FROM [SR]

  PRINT @countnotification

  Change the print part to your netsend command.

  Without more information, cant really comment on whether you need a Count(Distinct *) or other scenarios.

  gsc_dba