Đang chuẩn bị liên kết để tải về tài liệu:
Sams Microsoft SQL Server 2008- P10

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 Console.WriteLine Current Jobs Console.WriteLine Environment.NewLine Dim job As Job For Each job In jobs If job.Status JobStatusEnum.Running Or job.Status JobStatusEnum. New Then 1 New goes away soon Console.WriteLine --------------------------------- Console.WriteLine JobID 0 job.JoblD Console.WriteLine --------------------------------- Console.WriteLine Action 0 job.Action Console.WriteLine Description 0 job.Description Console.WriteLine Machine 0 job.Machine Console.WriteLine Name 0 job.Name Console.WriteLine Path 0 job.Path Console.WriteLine StartDateTime 0 job.StartDateTime Console.WriteLine Status 0 job.Status Console.WriteLine Type 0 job.Type Console.WriteLine User 0 Environment.NewLine job.User runningJobCount 1 End If Next job If runningJobCount 1 Then message There is 1 running job. Else message String.Format There are 0 running jobs. runningJobCount End If Console.Write 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 www.verypdf.com 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 .