This topic has not yet been rated - Rate this topic

ReportingService2010.SetExecutionOptions Method

SQL Server 2008 R2

SQL Server 2012

Sets execution options and associated execution properties for a specified item. This method applies to the Report item type.

Namespace: ReportService2010
Assembly: ReportService2010 (in ReportService2010.dll)

Syntax

C++

JScript

'Declaration
<SoapHeaderAttribute("TrustedUserHeaderValue")> _
<SoapDocumentMethodAttribute("http://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer/SetExecutionOptions", RequestNamespace := "http://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer",  _
	ResponseNamespace := "http://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer",  _
	Use := SoapBindingUse.Literal, ParameterStyle := SoapParameterStyle.Wrapped)> _
<SoapHeaderAttribute("ServerInfoHeaderValue", Direction := SoapHeaderDirection.Out)> _
Public Sub SetExecutionOptions ( _
	ItemPath As String, _
	ExecutionSetting As String, _
	Item As ScheduleDefinitionOrReference _
)
'Usage
Dim instance As ReportingService2010
Dim ItemPath As String
Dim ExecutionSetting As String
Dim Item As ScheduleDefinitionOrReference

instance.SetExecutionOptions(ItemPath, _
	ExecutionSetting, Item)

Parameters

ItemPath: Type: System.String
The fully qualified URL of the item including the file name and, in SharePoint mode, the extension.

ExecutionSetting: Type: System.String
A string that describes when the item executes. The value can be either Live or Snapshot.

Item: Type: ReportService2010.ScheduleDefinitionOrReference
The schedule definition or shared schedule (ScheduleDefinitionOrReference object) that the report server uses to execute an item on a schedule.

Remarks

The table below shows header and permissions information on this operation.

SOAP Header Usage

(In) TrustedUserHeaderValue

(Out) ServerInfoHeaderValue

Native Mode Required Permissions

UpdatePolicy

SharePoint Mode Required Permissions

EditListItems

The Item parameter is valid only if the value of the ExecutionSetting parameter is Snapshot. Set the value of Item to Nothing (Nothing in Visual Basic) if ExecutionSetting is set to Live. If you are using a shared schedule, set the value of Item to a ScheduleReference object that references an existing shared schedule. If you are defining a unique schedule, set the value of Item to the ScheduleDefinition object that defines a unique schedule. If the execution options for an item are based on a shared schedule and that shared schedule is deleted, the schedule is then associated with the individual item.

If you change the value of ExecutionSetting from Live to Snapshot, the item is removed from the cache.

Examples

Imports System
Imports System.IO
Imports System.Text
Imports System.Web.Services
Imports System.Web.Services.Protocols

Class Sample

    Public Shared Sub Main()

        Dim rs As New ReportingService2010()
        rs.Url = "http://<Server Name>/_vti_bin/ReportServer/" + _
            "ReportService2010.asmx"
        rs.Credentials = _
            System.Net.CredentialCache.DefaultCredentials

        Dim definition As New ScheduleDefinition()
        definition.StartDateTime = _
            New DateTime(2003, 2, 22, 10, 15, 0)
        Dim recurrence As New MinuteRecurrence()
        recurrence.MinutesInterval = 60
        definition.Item = recurrence

        Try
            rs.SetExecutionOptions("http://<Server Name>" + _
                "/Docs/Documents/AdventureWorks Sample Reports/" + _
                "Sales Order Detail.rdl", _
                "Snapshot", definition)
        Catch ex As SoapException
            Console.WriteLine(ex.Detail.OuterXml)
        End Try

    End Sub

End Class

Reference

ReportingService2010 Class

ReportService2010 Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD