Running Batch Files from SQL

[Liz Harrison]

Hi,

I'm trying to run a simple batch file from a SQL job (SQL 7.0 sp4). No errors are received but the job does not complete. When I try to run the job manually, I get a message stating "Error 22022: SQLServerAgent Error: Request to run job my_job (from User DomainAdminUser) refused because the job is already running from a request by Schedule 127 (Schedule 1).

The services are running as a domain admin account.


Help!

Thanks in advance.

[Ray Miao]

What did you try to do in the job?


------------
Liz Harrison at 2/28/2002 5:39:26 AM

Hi,

I'm trying to run a simple batch file from a SQL job (SQL 7.0 sp4). No errors are received but the job does not complete. When I try to run the job manually, I get a message stating "Error 22022: SQLServerAgent Error: Request to run job my_job (from User DomainAdminUser) refused because the job is already running from a request by Schedule 127 (Schedule 1).

The services are running as a domain admin account.


Help!

Thanks in advance.