th3Whip

I'm looking to create a sql sever agent job that will check for a specific error that gets logged to a table. if I do this:

select count(*) from tableA

where tableA.Field1 like '%error%'

the results will be 0, 1, 2, etc.

How can I check that it only moves on if count > 0?

Thanks

col1 col2 col3

A 1/7/2013 1/13/2013

B 1/14/2013 1/20/2013

C 1/21/2013 1/27/2013

select col1 where getdate() between col2 and col3

Whats the easiest way to do this is SQL. If getdate()=col2 or col3,

When I try to link a table in Access 07 to Outlook 07, I'm getting the following:

Object or class does not support the set of events

In Access, I created a blank db, selected a table, then

External Data->More->Outlook Folder->Link to data source...

Once I click ok, i get the warning above and the outlook export dialogue never opens.

I've checked the sys logs but noting is recorded. Any ideas?

i need to find a file by a specific modified date, then search the resulting files for a string. I know I can use:

grep 'string' filename

to find a string, so do i need to do something like:

grep 'string' (find date=01/01/2010)