Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-22 : 08:38:42
|
John writes "I need to start an existing SQL Server 'job' via the web but am having problems with permissions.
The error message i get states the user needs administrator rights to start a job, but even when I grant admin rights to the internet guest user account it still complains about permissions and the job does not start.
The job i created starts access with a macro which prepares a file for downloading. This part works when started manually from within Sql7. Though when i call a stored procedure via ADO with the start job it fails with permission problems.
the line the the stored procedure that fails when called from an ASP web page is :
exec msdb.dbo.sp_start_job @job_name = 'PrepareDownload'
Can you help please?
Windows NT4 SP6, SQL7 no SP." |
|
|
|
|
|
Scheduling a SQL Server Job via the web.