Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Error Logs for JOB

Author  Topic 

linda9898
Starting Member

28 Posts

Posted - 2008-05-25 : 04:36:57
Hi ,

How can i create an error log txt file for the jobs at the sql2005? the same like it was in the 2000.

many thanks

mdubey
Posting Yak Master

133 Posts

Posted - 2008-05-25 : 09:54:28
My friend,

You are creating a error log file, you are creating a report file. In this report file you come to know tha Job got success or faillure and the extention of the file is to be .txt. I guess you are assuming this to be "an error log file".

Please let me know, is this you are looking for.

Manoj
MCP, MCTS
Go to Top of Page

linda9898
Starting Member

28 Posts

Posted - 2008-05-25 : 10:25:58
Hi,

Where can i create that files? at the job properties ? cause i didnt find any place there where i can create files.

thanks
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-25 : 10:49:13
Are you talking about jobs created through maintenance plan? Like write a report to text file.
Go to Top of Page

linda9898
Starting Member

28 Posts

Posted - 2008-05-25 : 11:28:18
im talking about job the run ssis that i built , not jobs created through maintenance plan.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-25 : 14:14:53
You should config log file in the package then.
Go to Top of Page
   

- Advertisement -