SQL Server Developer Center > SQL Server Forums > SQL Server Notification Services > How to create one time schedules for subscriptons
Ask a questionAsk a question
 

QuestionHow to create one time schedules for subscriptons

  • Thursday, November 05, 2009 1:52 PMitsRashmi Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    hi

    I have  a requirement to have a scheduled subscription where no recurrence is required that means notification should go only once. I cant configure this as event based as I required it to be triggered on some button click and should send notification and then should be done.

    I gone through ScheduleRecurrence related documentation but it is not useful.

    Please suggest.

    Regards,
    Rashmi

All Replies

  • Wednesday, November 11, 2009 4:24 AMNai-dong Jin - MSFTMSFT, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Hi,

    I'm not sure what you mean by button click, do you mean you want to create the task schedule from ASP.NET webform (Button Click event)?

    If so, you can try the following article:

    http://stackoverflow.com/questions/542804/asp-netbest-way-to-run-scheduled-tasks

    Thanks.
    Microsoft Online Community Support Please remember to mark the replies as answers if they help and unmark them if they provide no help.
  • Friday, November 20, 2009 1:42 PMitsRashmi Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    hi

    actually I am using SQL server notification services and in simple language I need to send a mail ... may be say when i click on "Notify User" button on user interface. I have created scheduled subscription for the same. now schedule frequency is mandatory for it and it has values like Daily, weekly ... but i dont need recurrance.. please suggest if i am doing anytihng conceptually wrong here.

    Thanks
    Rashmi
  • Tuesday, November 24, 2009 11:49 AMitsRashmi Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    I explored more and found chronicals to do the same but in that case do my chronical data keep on increasing ... i mean it never disables subscription it just checks it against chronical data. am i right?

    one more query is Schedule Start property compulsary? if not then when mail will be shooted when i subscriobe to scheduled subscription where no schedule start or recurrence is specified?



    Regards,
    Rashmi