SQL Server Agent Output Log

#1

Hi,
I have written a SQL server Agent job that deletes some rows in a table that
meets our criteria. It works perfect. But I have a question, is there any way
that after the job it tells me that it has deleted so many number of rows?

my sql statement is

delete from xxxtable where datediff(hh,timegen, getdate()-1)<=24

so now I need the output log to be

job started successful at xxxx time and 1000 rows deleted

Thanks in advance.

#2

You can do this in the DTS log by using the WriteStringToLog method

Allan

"spark" <spark (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,
I have written a SQL server Agent job that deletes some rows in a table
that
meets our criteria. It works perfect. But I have a question, is there
any way
that after the job it tells me that it has deleted so many number of
rows?

my sql statement is

delete from xxxtable where datediff(hh,timegen, getdate()-1)<=24

so now I need the output log to be

job started successful at xxxx time and 1000 rows deleted

Thanks in advance.

#3

Thanks, I've got it

"spark" wrote:

Quote:

Hi,
I have written a SQL server Agent job that deletes some rows in a table that
meets our criteria. It works perfect. But I have a question, is there any way
that after the job it tells me that it has deleted so many number of rows?

my sql statement is

delete from xxxtable where datediff(hh,timegen, getdate()-1)<=24

so now I need the output log to be

job started successful at xxxx time and 1000 rows deleted

Thanks in advance.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL Server Agent Output Log

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

SQL Server Agent Output Log - 11-17-2005 , 03:16 PM

Re: SQL Server Agent Output Log - 11-17-2005 , 03:36 PM

RE: SQL Server Agent Output Log - 11-21-2005 , 01:31 PM