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 (AT) hotmail (DOT) com> wrote

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 (AT) 1568 (DOT) com> wrote

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 (AT) hotmail (DOT) com> wrote

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 (AT) 1568 (DOT) com> wrote

No one place jumps out immediately other then Books Online. Normally, unless
you are attempting to solve a particular problem, it is wise to leave the
locking behavior to the database engine. It does a decent job 'most' of the
time.

--
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 (AT) hotmail (DOT) com> wrote

No one place jumps out immediately other then Books Online. Normally, unless
you are attempting to solve a particular problem, it is wise to leave the
locking behavior to the database engine. It does a decent job 'most' of the
time.

--
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 (AT) hotmail (DOT) com> wrote