MS SQL Jobs

Discussion in 'Databases' started by tonto, Mar 2, 2004.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. tonto

    tonto

    Does anyone know if discountASP allows the creation of MS SQL Jobs? I am currently hosted by a company that offers MS SQL but apparently they can not give me permissions to create Jobs on their MS SQL server. Of course I found this out after signing up. I am thinking of switching to discountASP because of this but I want to make sure I don't run into the same problem.
     
    tonto, Mar 2, 2004
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    SQL job is not supported

    Reason: simple... SQL Job runs as a single user (whatever the user that SQL Agent runs with).


    quote:Originally posted by tonto

    Does anyone know if discountASP allows the creation of MS SQL Jobs? I am currently hosted by a company that offers MS SQL but apparently they can not give me permissions to create Jobs on their MS SQL server. Of course I found this out after signing up. I am thinking of switching to discountASP because of this but I want to make sure I don't run into the same problem.
    </blockquote id="quote"></font id="quote">
     
    Bruce, Mar 3, 2004
    #2
  3. pjoyce

    pjoyce

    Alas, outside of a dedicated box, you won't find this feature offered for SQL Server (At least as far as I know.) However, DASP does have an job scheduler that hits a specific URL. So unless you really need a DTS job for some reason, you could write code that does the job and chances are it would be faster than a DTS job. In fact, chances are two monkeys scribbling out the data and typing it back in would probably be faster than a DTS job, but that's another issue...

    quote:Originally posted by tonto

    Does anyone know if discountASP allows the creation of MS SQL Jobs? I am currently hosted by a company that offers MS SQL but apparently they can not give me permissions to create Jobs on their MS SQL server. Of course I found this out after signing up. I am thinking of switching to discountASP because of this but I want to make sure I don't run into the same problem.
    </blockquote id="quote"></font id="quote">
     
    pjoyce, Mar 5, 2004
    #3
  4. Bruce

    Bruce DiscountASP.NET Staff

    YUKON would change all these... So sit tight.

    quote:Originally posted by pjoyce

    Alas, outside of a dedicated box, you won't find this feature offered for SQL Server (At least as far as I know.) However, DASP does have an job scheduler that hits a specific URL. So unless you really need a DTS job for some reason, you could write code that does the job and chances are it would be faster than a DTS job. In fact, chances are two monkeys scribbling out the data and typing it back in would probably be faster than a DTS job, but that's another issue...

    quote:Originally posted by tonto

    Does anyone know if discountASP allows the creation of MS SQL Jobs? I am currently hosted by a company that offers MS SQL but apparently they can not give me permissions to create Jobs on their MS SQL server. Of course I found this out after signing up. I am thinking of switching to discountASP because of this but I want to make sure I don't run into the same problem.
    </blockquote id="quote"></font id="quote">
    </blockquote id="quote"></font id="quote">
     
    Bruce, Mar 7, 2004
    #4
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page