Re: Alert in Email !!!

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: Can I set multiple filters?
    ... Post your suggestions for SQL Server here: ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... The best way to query the database is to know how to query the database ...
    (microsoft.public.sqlserver.clients)
  • Re: Tools For Scanning Data?
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... >> Corey, ... If we are transferring a database from the old SQL Server to a new, ...
    (microsoft.public.sqlserver.security)
  • Re: SQL server 2005 Developer setup
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... Tell me if you need SQL Server installation logs. ...
    (microsoft.public.sqlserver.setup)
  • Re: Tools For Scanning Data?
    ... What you are concerned about is the occurrence of calls to those stored procedures within your database procedures. ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... If we are transferring a database from the old SQL Server to a new, ...
    (microsoft.public.sqlserver.security)
  • Re: Getting SQL Server security notifications
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... For a while now I've been administering SQL Server DBs. ...
    (microsoft.public.sqlserver.security)
Loading