Post reply

Subscription runtime

  • September 15, 2004 at 3:50 pm

    #109243

    I have a number of subscriptions that I'd like to change to a different runtime. Does anyone know which table and column name contains the runtime? I've looked at the subscriptions table and the schedule table and just about every other one looking for the next run time. It would be much faster changing the time from the backend than to go change every subscription through RS.

    Thanks

     

  • September 16, 2004 at 4:44 pm

    #523432

    Scheduled subscriptions are just SQL Agent jobs. You could just change the time on the jobs, but that may have other consequences within the RS database.

    Another option would be to knock up a quick .net app that uses the web service to modify the times.

    --------------------
    Colt 45 - the original point and click interface

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply