MS SQL Jobs

[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.

[bruce]

SQL job is not supported

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


[b]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]

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...

[b]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]

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

[b]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...

[b]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">