Friday, February 24, 2012

can't manully start jobs

The job in SQL server agent won't manully start after installed SP3 for SQL
server 2000. But scheduled jobs are runing fine automatically.
Thanks for any reply.What errors do you get? What is in the SQLAgent.out file in
the Log directory?
-Sue
On Mon, 7 Nov 2005 08:16:15 -0800, new
<new@.discussions.microsoft.com> wrote:

>The job in SQL server agent won't manully start after installed SP3 for SQL
>server 2000. But scheduled jobs are runing fine automatically.
>Thanks for any reply.|||This may be a given, but make sure that the EM registration for this instanc
e
has the proper rights to exe jobs. If you are using Windows Authentication o
n
this registration, then make sure the win login you are using has sa. Some
permission levels allow you to view jobs, but can not execute them.
Thanks,
Rick MCP
"new" wrote:

> The job in SQL server agent won't manully start after installed SP3 for SQ
L
> server 2000. But scheduled jobs are runing fine automatically.
> Thanks for any reply.

No comments:

Post a Comment