July 4, 2003 at 7:22 am
Hi,
i'm trying to start a job from an asp page by using "sp_start_job" procedure. The job owner is a domain user also used to connect from internet (nt autentication), to the web page which call the job.
I could start the job only if the domain user is member of sysadmin role. I don't want that. Do you know any other possibilities?
July 4, 2003 at 7:26 am
Insert a row into a table, have your job poll that table, when it finds a row, run the job you need to run.
Andy
July 4, 2003 at 9:39 am
Hi Andy,
thank you for your answer. Sorry, but I didn't understand well what you suggested me.
My problem is the impossibility to start a job from a web page which open a trusted connection to a SQL 2000 server. The Web server (IIS) rappresents the NT user logged in from the web page. That user, is the owner of the job. I've noticed that I've to add that user at least to the dbo_owner master role to start the job regulary.
Could you please explain again your suggestion?
Thank you
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply