Alert in Email !

Dear Professional,
I am using one extended stored procedure to send email from SQL Server. Now
the question is how can I email my self from SQL Server if CPU usage greater
than 30% or available memory greater than specific value,
Can any body guide me regarding that?
Thanks
Check into setting an Alert using Performance Monitor [Administrative
Tools], [Performance].
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Rogers" <naissani@.hotmail.com> wrote in message
news:u6gK5tjDHHA.3492@.TK2MSFTNGP02.phx.gbl...
> Dear Professional,
> I am using one extended stored procedure to send email from SQL Server.
> Now the question is how can I email my self from SQL Server if CPU usage
> greater than 30% or available memory greater than specific value,
> Can any body guide me regarding that?
> Thanks
>
|||First of all thanks for your reply, in the Action Tab there is a option to
execute any batch file, now I want to execute my sql server job through
this, is there any command available which I run through batch file that
will run one of SQL JOB.
Thanks and waiting for your reply.
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:%238mI2%23mDHHA.4060@.TK2MSFTNGP03.phx.gbl...
> Check into setting an Alert using Performance Monitor [Administrative
> Tools], [Performance].
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "Rogers" <naissani@.hotmail.com> wrote in message
> news:u6gK5tjDHHA.3492@.TK2MSFTNGP02.phx.gbl...
>
|||From a Batch file, you could use osql.exe (or sqlcmd.exe for 2005) and
EXECUTE sp_start_job.
Check in Books Online about osql/sqlcmd, and also about sp_start_job.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Rogers" <naissani@.hotmail.com> wrote in message
news:%238$%23RroDHHA.4060@.TK2MSFTNGP03.phx.gbl...
> First of all thanks for your reply, in the Action Tab there is a option to
> execute any batch file, now I want to execute my sql server job through
> this, is there any command available which I run through batch file that
> will run one of SQL JOB.
> Thanks and waiting for your reply.
>
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:%238mI2%23mDHHA.4060@.TK2MSFTNGP03.phx.gbl...
>
|||Thanks, one last thing if you can help me out. I want to learn locking
machanism in dept in SQL Server but I can see so many definition, any
website you know that can explain the locking by practical query and in
detail?
Thanks
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:emYZJ1oDHHA.1224@.TK2MSFTNGP04.phx.gbl...
> From a Batch file, you could use osql.exe (or sqlcmd.exe for 2005) and
> EXECUTE sp_start_job.
> Check in Books Online about osql/sqlcmd, and also about sp_start_job.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "Rogers" <naissani@.hotmail.com> wrote in message
> news:%238$%23RroDHHA.4060@.TK2MSFTNGP03.phx.gbl...
>