June 5, 2009 at 5:20 pm
When I ran the task as a scheduled job, I could not find the results.
There must be an easy way to do this....Help please.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
June 6, 2009 at 5:34 am
Under the job step, go to the Options page and there's a option there to write the job step's output to a file, either overwrite or append.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 8, 2009 at 11:57 am
Yes I found that option. Is that functionality available on sql 2000?
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
June 8, 2009 at 12:13 pm
I'm sure it was. Don't recall where it's set though.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 8, 2009 at 2:44 pm
Ok. I will do the research. Thanks again.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
June 9, 2009 at 9:23 am
In SQL 2000, the option is also on the Advanced tab of the job step.
Greg
June 10, 2009 at 12:38 am
Results are also logged to the SQL error log, whenever checkdb is run.
June 10, 2009 at 10:35 am
Even when run as a sql agent job?
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
June 10, 2009 at 10:58 am
Yup.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply