Re: Alert in Email !!!

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@xxxxxxxx> wrote in message
news:emYZJ1oDHHA.1224@xxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxx> wrote in message
news:%238$%23RroDHHA.4060@xxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxx> wrote in message
news:%238mI2%23mDHHA.4060@xxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxx> wrote in message
news:u6gK5tjDHHA.3492@xxxxxxxxxxxxxxxxxxxxxxx
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










.

Relevant Pages

  • Re: Alert in Email !!!
    ... locking behavior to the database engine. ... Most good judgment comes from experience. ... machanism in dept in SQL Server but I can see so many definition, ... Check in Books Online about osql/sqlcmd, ...
    (microsoft.public.sqlserver.clients)
  • Re: Alert in Email !!!
    ... locking behavior to the database engine. ... Most good judgment comes from experience. ... machanism in dept in SQL Server but I can see so many definition, ... Check in Books Online about osql/sqlcmd, ...
    (microsoft.public.sqlserver.clients)
  • Re: /3GB switch in 64-bit environment
    ... SQL Server 2005, Standard Edition allows 4 GB memory -if that's of any help. ... Most good judgment comes from experience. ...
    (microsoft.public.sqlserver.setup)
  • Re: Error when installing SQL Server 2005 Developer on Vista Ultimate
    ... Most good judgment comes from experience. ... onto a PC running Vista Ultimate, I get the following error message: ... Refer to server error logs and setup logs for more information. ... The SQL server service is being run with the Local System account. ...
    (microsoft.public.sqlserver.setup)
  • Re: Local connection to SQL Server 2005 Express fails
    ... Most good judgment comes from experience. ... H. Norman Schwarzkopf ... articles and I still get the same connection error. ... When connecting to SQL Server 2005, this failure may be caused by the ...
    (microsoft.public.sqlserver.connect)