This topic has been archived. It cannot be replied.
-
工作学习 / 专业技术讨论 / 请问在SQL SERVER, 怎样使Procedure自动运行?怎样在JOB中设置?我设好的JOB, 其运行结果总是失败.
-xxu999(杰姆);
2005-9-13
(#2501095@0)
-
得启动SQL ALERT吧...
-hard20(hard20);
2005-9-13
(#2501229@0)
-
失败了就查找原因啊...没有LOG 吗?...
-leoxxll(leoxxll);
2005-9-14
(#2501752@0)
-
See inside.When I set the step on job, it shows
Error 229: EXECUTE permission denied on object 'sp_enum_sqlagent_subsystems', database 'msdb', owner 'dbo'.
Although it can continue to set but I think my job did not set properly.
My procedure's owner is me. I am not 'dbo' but I can act as 'dbo'. Does The err msg mean that I must act as 'dbo'?
Any one know how to set?
Thanks.
-xxu999(杰姆);
2005-9-14
{391}
(#2501836@0)
-
permission
-zxcvb(朝天椒);
2005-9-14
(#2501847@0)
-
My procedure's owner is me. I am not 'dbo' but I can act as 'dbo'. Does The err msg mean that I must act as 'dbo'?
-xxu999(杰姆);
2005-9-14
(#2501856@0)
-
Do you have the permission to run ''sp_enum_sqlagent_subsystems''? if not, please grant the permission to the owner of the job.
-handd(学做盆景的大熊猫);
2005-9-14
(#2501882@0)
-
就是权限问题嘍...看看 sp_enum.... 的权限设置成可以给你EXEC了吗?
-leoxxll(leoxxll);
2005-9-14
(#2501872@0)