shanghai2004
Programmer
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
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