Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

SetExecutionOptions Method

SQL Server 2000

ReportingService.SetExecutionOptions Method

Sets execution options and associated execution properties for a specified report.

Public Sub SetExecutionOptions(
   ByVal Report As String _
   ByVal ExecutionSetting As [Namespace].ExecutionSettingEnum _
   ByVal Item As [Namespace].ScheduleDefinitionOrReference _
   Member of [Namespace].ReportingService

public void SetExecutionOptions(
   string Report,
   [Namespace].ExecutionSettingEnum ExecutionSetting,
   [Namespace].ScheduleDefinitionOrReference Item
   Member of [Namespace].ReportingService
The full path name of the report.
One of the ExecutionSettingEnum values that describe when the report executes. The value can be either Live or Snapshot.
The schedule definition or shared schedule (ScheduleDefinitionOrReference object) that the report server uses to execute a report on a schedule.

Operation Description
Update Policy Required to set the execution options of a report.


The Item parameter is valid only if the value of the ExecutionSetting parameter is Snapshot. Set the value of Item to null (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, which references an existing shared schedule. If you are defining a unique schedule, set the value of Item to the schedule definition (ScheduleDefinition object) that defines a unique schedule. If the execution options for a report are based on a shared schedule and that shared schedule is deleted, the schedule is then associated with the individual report.

Changing the value of ExecutionSetting from Live to Snapshot can result in the removal of a report from the cache. If the report is cached, the CacheReport parameter is set to false.


To compile the following code example, you must reference the Reporting Services WSDL and import certain namespaces. For more information, see Compiling and Running Code Examples. The following code example uses the SetExecutionOptions method to set the options for the Company Sales report to run as a snapshot on a schedule:

Imports System
Imports System.Web.Services.Protocols

Class Sample
   Public Shared Sub Main()
      Dim rs As New RSWebService()
      rs.Credentials = System.Net.CredentialCache.DefaultCredentials
      Dim definition As New DataSourceDefinition()
      definition.CredentialRetrieval = CredentialRetrievalEnum.Integrated
      definition.ConnectString = "data source=(local);initial catalog=AdventureWorks2000"
      definition.Enabled = True
      definition.EnabledSpecified = True
      definition.Extension = "SQL"
      definition.ImpersonateUser = False
      definition.ImpersonateUserSpecified = True
      definition.Prompt = Nothing
      definition.WindowsCredentials = False
         rs.SetDataSourceContents("/SampleReports/AdventureWorks", definition)
      Catch e As SoapException
      End Try
   End Sub 'Main
End Class 'Sample

using System;
using System.Web.Services.Protocols;

class Sample
   public static void Main()
      RSWebService rs = new RSWebService();
      rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
      ScheduleDefinition definition = new ScheduleDefinition();

      // Create the schedule definition.
      definition.StartDateTime = new DateTime( 2003, 2, 22, 10, 15, 0 );
      MinuteRecurrence recurrence = new MinuteRecurrence();
      recurrence.MinutesInterval = 60;
      definition.Item = recurrence;

      // Apply execution settings
         rs.SetExecutionOptions("/SampleReports/Company Sales", ExecutionSettingEnum.Snapshot, definition);

      catch (SoapException ex)
See Also

ReportingService Class

Reporting Services Web Service Library

© 2015 Microsoft