April 9, 2010 at 1:03 pm
Hi.
Just started working with a SQL 2005 server. SQL Server 2005 Service Pack 3 (build 9.00.4053.00)
We've created a new SQL Agent job, and on the job step, in the Advanced tab, have specified a specific file path in Output File:
However, problem we're seeing that the corresponding VIEW button located in the Advanced section of the step in the Job properties windows is greyed out.
We know the path is valid, when we run the job, it completes OK, and the correct file is created in the path as expected. We can open the file manually using Notepad.
Does anyone know how/if this deactivated View button problem can be resolved, or is the View button remaining "greyed-out" an expected behavior ?
Any replies would be greatly appreciated. 🙂
Thanks!
April 9, 2010 at 2:36 pm
Hello
If you click the 'help' button on the top of the job properties form books online opens up and explains:
View
In Microsoft SQL Server 2005, this button is disabled for viewing output files. Instead, use Notepad to view job step output files.
April 9, 2010 at 2:41 pm
Kenneth Langner Jr. (4/9/2010)
HelloIf you click the 'help' button on the top of the job properties form books online opens up and explains:
View
In Microsoft SQL Server 2005, this button is disabled for viewing output files. Instead, use Notepad to view job step output files.
Sorry I skipped over a couple lines down where it says
View
After the job step has run at least once, click View to view its output in the table.
So it should not be grayed out.. sorry for the confusion.
April 9, 2010 at 2:43 pm
View button will only show for SQL 2000 servers.
April 10, 2010 at 8:30 am
Hi,
Thanks much for your helpful replies. Much appreciated !
Unfortunately, looking like this is expected behavior for file output. Oh well ..........
Thanks again !
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply