Re: Alert in Email !!!

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: try...catch execution issue
    ... If I execute a procedure, an error occurs, call the ... But I would suggest that when you use TRY-CATCH, you don't care about the ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.programming)
  • Re: Problem with bulk load security.
    ... go back read my previous post about using EXECUTE AS ... you need to impersonate a *server login*. ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.security)
  • Re: Starting up database customers every minute or so in SQL LOG
    ... Did you check the initial few lines of the sql log as I mentioned?If you are ... unable to find the location of the error log, then execute the below command ... priority class 'normal'(n CPU detected) " where n indicates the number. ... SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: proper permissions for aspnetdb membership access
    ... Windows built-in account. ... application's application pool to execute the T-SQL statements. ... Open your SQL Server Management Studio with a local ... If it does not exist in the logins of your SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server calling a Universe Subroutine
    ... I'm just trying to run from Sql Analyzer now but eventually it will be ... see if an error is being thrown that Sql Server is hiding and I check ... I'm trying to call an .NET console exe program from a trigger in Sql ... Services calling other services or trying to execute something ...
    (comp.databases.pick)
Loading