Help with Auto Notifications

We currently have SMS dumping data into sql, and what we are trying do is
when sms does an inventory it captures the amount of RAM and puts it in a
sql table, it also keeps a history in another table. We have an issue were
RAM is starting to be remove, so we are wanted to have a scheduled task that
will compare the 2 values in the table if the current inventoried RAM is
less than the Historical inventoried RAM, an email notification would be
sent. Is this possible, if so how would go about creating this task.
thanks - mikeWhat version of SQL Server?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mike" <mlehman@.osc.uscg.mil> wrote in message news:OLr54f$gGHA.1612@.TK2MSFTNGP04.phx.gbl..
.
> We currently have SMS dumping data into sql, and what we are trying do is
when sms does an
> inventory it captures the amount of RAM and puts it in a sql table, it als
o keeps a history in
> another table. We have an issue were RAM is starting to be remove, so we
are wanted to have a
> scheduled task that will compare the 2 values in the table if the current
inventoried RAM is less
> than the Historical inventoried RAM, an email notification would be sent.
Is this possible, if so
> how would go about creating this task.
> thanks - mike
>|||SQL 2000 SP 4
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uiLjDv$gGHA.3424@.TK2MSFTNGP05.phx.gbl...
> What version of SQL Server?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Mike" <mlehman@.osc.uscg.mil> wrote in message
> news:OLr54f$gGHA.1612@.TK2MSFTNGP04.phx.gbl...
>