
November 19th, 2003, 05:57 AM
|
|
Junior Member
|
|
Join Date: Nov 2003
Location: italy
Posts: 5
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
SQL Server Agents AND CMDEXE Steps
Hi there
I installed SQLServer 2000 on windows 2000 server and successfuly re-created jobs previously trasformed in *.sql file.
In one of those some steps invokes cmdexe.
After the job started hourglass appears for few seconds and after that nothing happens.
If I take a look to the Application Event viewer I find that :
1) an unpredictable stop of SqlServerAgent occurred
2) A succesfull restart of the same gent occurred.
I tried to reconfigure access and Sysadmin privileges for executing CmdExe (cause I noticed that jobs with only transact sql steps worked perfectly) with no results.
Please can someone help me?
Thank you in advance
|