Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

can not start a job after the job was force stopped

Status
Not open for further replies.

shanghai2004

Programmer
Dec 16, 2004
37
CA
Dear Expert,

The job execute a batch file below:
=====================
osql -E -d tenrox_dev -n -b -i "c:\sama data\mssql\script files\tenrox\g_alter_user_sp.sql"

echo Alter Stored Procedures(type User) completed
=====================

Everything worked fine until I add two lines, date and time, to the beginning of the batch.
by look at the log file, it was waiting for entering time.
Here is the log file show:

C:\WINDOWS\system32>osql -E -d tenrox_dev -n -b -i "c:\sama data\mssql\script files\tenrox\g_alter_user_sp.sql"

C:\WINDOWS\system32>echo Alter Stored Procedures(type User) completed
Alter Stored Procedures(type User) completed


C:\WINDOWS\system32>date
The current date is: 31/03/2006
Enter the new date: (dd-mm-yy)

Then I stoppe the job menually. I removed the two lines I added and tried to start the job again, I got error message:

Error 22022: SQLServer Agent Error: Request to run job alter user stored procedures for tenrox_dev(from User SAMA\wli) refused because the job is altreday running from a request by User SAMA\wli.

I tried to kill the process, but nothing happen.

Help please


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top