View button for step output logs greyed out

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)

View button for step output logs greyed out

Author

Topic

mivey4
Yak Posting Veteran

66 Posts

Posted - 2008-06-12 : 05:49:08

Hi.

My company has upgraded some of the database systems to SQL 2005 while other have a fresh install.

The problem we're seeing is that the view button located in the Advanced section of the steps in the Job properties windows is greyed out. The path is valid as we can copy the path and paste it at the run command and view the log.

Does anyone know how this problem can be resolved? If we select to log the results to a table; we have access to the corresponding view button but not the one for the file system logging.

We rely heavily on this feature since we used it often under SQL 2K. Can anyone provide any helpful details to resolve this or has anyone seen this problem before???

Any helpful replies would be highly appreciated.

Thanks!

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-12 : 11:14:37

Do you mean View job history? Didn't get what you exactly meant.

mivey4
Yak Posting Veteran

66 Posts

Posted - 2008-06-12 : 11:43:38

Thanks for replying Sodeep.

Actually I meant the "view" button available in the Advanced property section for every job step.
So going to the property of any job:

1. Select "Steps"
2. Double-click the step name or Select the step and click the "Edit" button
3. Select "Advanced" in the right pane

On the right side you'll see the "Output File" section, then a text box that populates with the path to the log file that will be used to log the steps execution during run-time and finally to the right of that a "View" Button.

In SQL 2000 this view button was enabled when an actual log path was present and by pressing the view button you could actually have the log opened to view any errors.

In SQL 2005 this button is "greyed-out" and the only method to view the log that we have been able to utilize is to copy and paste the log path and file name from the text box into a run command.

Any ideas???

mivey4
Yak Posting Veteran

66 Posts

Posted - 2008-06-12 : 11:44:54

Oops. Small correction for my previous reply.

3. Select "Advanced" in the LEFT pane

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-12 : 11:52:01

Did you apply service packs and hot fixes to it?

mivey4
Yak Posting Veteran

66 Posts

Posted - 2008-06-12 : 11:56:31

Service Pack 1

Is this a known issue?