Tham khảo tài liệu 'sams microsoft sql server 2008- p10', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | Code Examples 431 Dim message As String Current Jobs Dim job As Job For Each job In jobs If Or JobStatusEnum. New Then 1 New goes away soon --------------------------------- JobID 0 --------------------------------- Action 0 Description 0 Machine 0 Name 0 Path 0 StartDateTime 0 Status 0 Type 0 User 0 runningJobCount 1 End If Next job If runningJobCount 1 Then message There is 1 running job. Else message There are 0 running jobs. runningJobCount End If message If runningJobCount 0 Then Return True Else Return False End If End Function The example s output is shown here Current Jobs 24 JobID jgbfw045virghsnsgvbv4n55 Action Render Description Machine SSRS2 lease purchase PDF Split-Merge on to remove this watermark. 432 CHAPTER 24 RS Utility Name Company Sales Path AdventureWorks Sample Reports Company Sales StartDateTime 9 29 2008 8 39 17 PM Status New Type User User SSRS2 Administrator There is 1 running job. The command completed successfully Some other useful scripts that you can execute with the RS utility include the following Deploy new reports RDL files and data sources Configure data sources Download contents of the Report Server Deploy to multiple servers simultaneously Set up subscriptions Refresh caches As you can see the RS utility can be used to accomplish almost anything you could use the Reporting Services web service to do. The work would be in developing script files to do it. Summary This chapter serves as an introduction to the RS utility. The RS utility can be .
