I have this query running every 15 Minutes with sqlagent.

It writes a message to winnt-eventlog which is captured by HPOVow

Primitive, but it works.

declare @DB_Criterium    int

/* ** criterium % must be...

we us HP ovow to monitor the physical disks, not the sqlserver infrastructure.

Here's Freud again

Aha-erlebness

there are some pittfalls with alerts

first of all, an alert only responds when it is enabled

You can check if sqlserver finds the group using Query ananlyser.

connect to the server position in the database

and execute :

use yourdb

go

EXEC master..xp_logininfo @acctname = 'yourdomain\yourgroup',@option = 'members'     -- who belongs...

this would be like pulling a cat insideout   (in a matter of speaking )

If you don't...

Can you try running the dts in the job with its proper name in stead of the guid ?

dtsrun /Npackage_name

Yes it has.

In fact, you can prepare and save your package (if you used the wizard, you must have seen the panel where it asks "run immediate , save as...

Is this package password protected ?

it's _the_ way for importing / exporting data.

Even the wizard is intuitive

EM (enterprise manager) \ databases \tables got to the righthand side, right-click...

did you put the jobowner to SA (and not a windows account) ?

can you perform a dbcc checkdb ?

Read about it in Books Online to check the options?

just to be sure ...

- you know EM does _not_ refresh automaticaly. You have top position on the...

so you can login and execute using _that_ (sqlagent) domain-account ?

Can you enable the jobstep's outputfile to capture windows output ?

jobstep\advanced outputfile

Is your sqlagent running using a windows-domain-account ?

When you run the package yourself, it's using your account to get network or share rights.

If it runs using localsystem, is has no...