SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    Afrika
    Join Date
    Jul 2004
    Location
    Nigeria
    Posts
    1,737
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    is it possible to schedule a job at runtime ?

    Hello guys,
    is it possible to schedule a job or batch at runtime ? either from a calling function or SP, to run at a specified time ?

    And if so, how can this be achieved in MS SQL?



    Ehi

  2. #2
    SitePoint Member WeatherSquareCom's Avatar
    Join Date
    Sep 2008
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yep, you need to do it through stored procs though

    see sp_add_job
    msdn.microsoft.com/en-us/library/ms182079.aspx

    sorry I'm new and can't post links.

    also make sure the account you use to connect with sql has the proper rights.

  3. #3
    Afrika
    Join Date
    Jul 2004
    Location
    Nigeria
    Posts
    1,737
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thanks.

    I finally got it sorted.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •