alternative to SQL Agent Jobs

Discussion in 'Databases' started by Jason Mauss, Sep 10, 2013.

  1. Jason Mauss

    Jason Mauss

    Is there anything else that can be done to "fake" the behavior of a SQL Agent Job? I know you guys don't allow SQL Agent Jobs in your SQL Server environment so I was wondering if there is any other way to schedule something to run or to schedule a web page to be requested so that something in the background can run. Any thoughts or ideas?

    Thanks,
    --Jason
     
    Jason Mauss, Sep 10, 2013
    #1
  2. RayH

    RayH DiscountASP.NET Lackey DiscountASP.NET Staff

    Use the Scheduled Task Manager in the Control Panel. Make an HTTP call to a webpage to execute a script.
     
    RayH, Sep 11, 2013
    #2
  3. Jason Mauss

    Jason Mauss

    Didn't know that was available - thanks! Is there any limit to the number of scheduled tasks you can have?
     
    Jason Mauss, Sep 11, 2013
    #3
  4. RayH

    RayH DiscountASP.NET Lackey DiscountASP.NET Staff

    It's 2.
     
    RayH, Sep 11, 2013
    #4
  5. Jason Mauss

    Jason Mauss

    I found something that looks like a good alternative - and allows more than 2 tasks too. Will probably go with this.
    https://www.setcronjob.com/
     
    Jason Mauss, Sep 11, 2013
    #5
  6. RayH

    RayH DiscountASP.NET Lackey DiscountASP.NET Staff

    Nice. Thank you for sharing.
     
    RayH, Sep 11, 2013
    #6
  7. martino

    martino DiscountASP.NET Staff

    That's awesome! I'm sure some of our users will find this helpful. Thank you for sharing!
     
    martino, Sep 11, 2013
    #7

Share This Page