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 - 2003-03-04 : 07:29:43
|
| jopa writes "OS: Win2K SP2SQL: 8.0 SP3After adding sp_makewebtask to a stored procedure with a @whentype=1 (default), on testing the call to sp_makewebtask is ok and sp completes successfully. When sp is added to a SQLAgent scheduled task however the job fails with an error as follows -"Executed as user: DOMAINNAME\MACHINENAME$. SQL Web Assistant: Could not execute the SQL statement. [SQLSTATE 42000] (Error 16805) Associated statement is not prepared [SQLSTATE HY007] (Error 0). The step failed."Changing the SQLAgent service to run under an administrator account and the job works fine." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-04 : 13:12:02
|
| Well apparently this stored procedure requires more access when run as a regular user. If you don't want to have the job run under the administrator account, then grant execute permission on the stored procedure to whatever acount you were using.Tara |
 |
|
|
|
|
|
sp_makewebtask fails when scheduled