November 19th, 2003, 05:57 AM
SQL Server Agents AND CMDEXE Steps
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