Expand Minimize
This topic has not yet been rated - Rate this topic

GetScheduleProperties Method

SQL Server 2000

ReportingService.GetScheduleProperties Method

Returns the properties of a shared schedule.

Public Function GetScheduleProperties( _
   ByVal ScheduleID As String _
) As [Namespace].Schedule _
   Member of [Namespace].ReportingService
public [Namespace].Schedule GetScheduleProperties(
   string ScheduleID
);
   Member of [Namespace].ReportingService
Parameters
ScheduleID
The ID of the schedule.
Return Values

A Schedule object that contains state information and the schedule definition for a single schedule.

Permissions

Operation Description
Read Schedules Required on the schedule to view its properties.

Example

To compile this 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 creates a shared schedule and then uses the GetScheduleProperties method to retrieve the properties of the newly created schedule:

Imports System
Imports System.Web.Services.Protocols

Class Sample
    Public Shared Sub Main()
      Dim rs As New ReportingService()
      rs.Credentials = System.Net.CredentialCache.DefaultCredentials
      
      Dim definition As New ScheduleDefinition()
      Dim scheduleID As String
      ' Create the schedule definition.
      definition.StartDateTime = New DateTime(2003, 3, 1, 14, 0, 0)
      Dim recurrence As New WeeklyRecurrence()
      Dim days As New DaysOfWeekSelector()
      days.Monday = True
      days.Tuesday = True
      days.Wednesday = True
      days.Thursday = True
      days.Friday = True
      days.Saturday = False
      days.Sunday = False
      recurrence.DaysOfWeek = days
      recurrence.WeeksInterval = 1
      recurrence.WeeksIntervalSpecified = True
      definition.Item = recurrence
      
      Try
         scheduleID = rs.CreateSchedule("My Schedule", definition)
         Console.WriteLine("Schedule created with ID {0}", scheduleID)
         
         rs.GetScheduleProperties(scheduleID)
         
         recurrence = CType(definition.Item, WeeklyRecurrence)
         Console.WriteLine(definition.StartDateTime)
         Console.WriteLine(definition.EndDate)
         
         days = recurrence.DaysOfWeek
         Console.WriteLine("Monday: {0}", days.Monday)
         Console.WriteLine("Tuesday: {0}", days.Tuesday)
         Console.WriteLine("Wednesday: {0}", days.Wednesday)
         Console.WriteLine("Thursday: {0}", days.Thursday)
         Console.WriteLine("Friday: {0}", days.Friday)
         Console.WriteLine("Saturday: {0}", days.Saturday)
         Console.WriteLine("Sunday: {0}", days.Sunday)
         Console.WriteLine("Weeks Interval: {0}", recurrence.WeeksInterval)
      
      Catch e As SoapException
         Console.WriteLine(e.Detail.InnerXml.ToString())
      End Try
   End Sub 'Main
End Class 'Sample
using System;
using System.Web.Services.Protocols;

class Sample
{
   public static void Main()
   {
      ReportingService rs = new ReportingService();
      rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

      ScheduleDefinition definition = new ScheduleDefinition();
      string scheduleID;
      // Create the schedule definition.
      definition.StartDateTime = new DateTime(2003, 3, 1, 14, 0, 0);
      WeeklyRecurrence recurrence = new WeeklyRecurrence();
      DaysOfWeekSelector days = new DaysOfWeekSelector();
      days.Monday = true;
      days.Tuesday = true;
      days.Wednesday = true;
      days.Thursday = true;
      days.Friday = true;
      days.Saturday = false;
      days.Sunday = false;
      recurrence.DaysOfWeek = days;
      recurrence.WeeksInterval = 1;
      recurrence.WeeksIntervalSpecified = true;
      definition.Item = recurrence;

      try
      {
         scheduleID = rs.CreateSchedule("My Schedule", definition);
         Console.WriteLine("Schedule created with ID {0}", scheduleID);

         rs.GetScheduleProperties(scheduleID);

         recurrence = (WeeklyRecurrence) definition.Item;
         Console.WriteLine(definition.StartDateTime);
         Console.WriteLine(definition.EndDate);

         days = recurrence.DaysOfWeek;
         Console.WriteLine("Monday: {0}", days.Monday);
         Console.WriteLine("Tuesday: {0}", days.Tuesday);
         Console.WriteLine("Wednesday: {0}", days.Wednesday);
         Console.WriteLine("Thursday: {0}", days.Thursday);
         Console.WriteLine("Friday: {0}", days.Friday);
         Console.WriteLine("Saturday: {0}", days.Saturday);
         Console.WriteLine("Sunday: {0}", days.Sunday);
         Console.WriteLine("Weeks Interval: {0}", recurrence.WeeksInterval);
      }

      catch ( SoapException e )
      {
         Console.WriteLine( e.Detail.InnerXml.ToString() );
      }
   }
}
See Also

ReportingService Class

Reporting Services Web Service Library

Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.