directory.
In the advanced tab under the job steps create an output file. This will
allow you to see the full description of the job execution. There is
nothing more annoying than not being able to see why a job failed.
如何设置作业输出文档：
-
In Object Explorer, connect to an instance of the Microsoft SQL Server Database Engine, and then expand that instance.
-
Expand SQL Server Agent, expand Jobs, right-click the job that contains the job step to be viewed, and click Properties.
-
In the Job Properties dialog, click the Steps page.
-
Click the job step to be viewed, and click Edit.
-
On the General page of the Job Step Properties dialog, you can view the type of job step and what it does.
-
Click the Advanced page to view the actions SQL Server Agent takes if the job step succeeds or fails, how many times the job step should be attempted, where the job step output is written, and the user the job step runs as.
查看输出文档
To view job step output
-
In the Job Step Properties dialog, click the Advanced page.
-
Depending on the version of SQL Server you are connected to, you can view either the job step output file or table as follows:
-
When you are connected to Microsoft SQL Server 2000, you can click View to view the output file in Notepad. Job steps cannot be logged to a table in SQL Server 2000.
-
When you are connected to Microsoft SQL Server 2005 or later, you can click View only when Log to table is checked. In this case, the job step output is written to the sysjobstepslogs table in the msdb database.
In SQL Server 2005 or later, the View button is disabled when job step output is written to a file. To view a job step output file, use Notepad.
-
