Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Microsoft SQL Server 2008 R2 Unleashed- P53:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major releases.Microsoft SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 464 CHAPTER 16 SQL Server Scheduling and Notification TIP The Retry options are useful for polling scenarios. For example you might have a job step that tests for the existence of a file during a given period of the day. The job can be scheduled to start at a time of day when the file is expected. If the file is not there and the step fails Retry Attempts can be set to poll again for the file. Retry Interval determines how often it retries and the combination of Retry Attempts and Retry Interval determines the total polling window. For example if you want to check for the file for 2 hours you can set Retry Attempts to 24 with a Retry Interval of 5 minutes. If the job step fails more than the number of retries the step completes in failure. The last set of options on the Advanced page relate to the output from the job step. Job step output can be saved to an output file that can be overwritten each time the job step is run or the output can be appended each time. The Log to Table option writes the job step output to the sysjobstepslogs table in the msdb database. The table contains one row for each job step with the Log to Table option enabled. If Append Output to Existing Entry in Table is enabled the sysjobstepslogs data row for the step can contain output for more than one execution. If this option is not selected the table contains only execution history for the last execution of the step. CAUTION If you choose the Append Output to Existing Entry in Table option the size of the sysjobstepslogs table will grow over time. You should consider using the sp_delete_jobsteplog stored procedure to remove data from the sysjobstepslogs table. This stored procedure has several different parameters that allow you to filter the data that will be removed. You can use these parameters to remove log data by job job step date or size of the log for the job step. Defining Multiple Jobs Steps You can define multiple jobs steps in a single job. This allows you to execute multiple .
