SQL Server Performance Forum – Threads Archive

SQL Job fails

Hi, I have a SQL job which writes the output log file to a share drive. When the job is executed it successed but the with a warning msg as below : cannot write logfile
\xyz.xyz est_1234.txt. Error 1059 : Circular service dependency was specified. The step succeeded. Can someone pls help me understand what is circular service dependency error means. Thanks in advance
Ananth

I feel the error u got is windows nt terminal server error.

In windows 2000 the win32 services performs the ScAutoStartServices marks for startup all the service entries that belong to the phase’s group. Then, ScAutoStartServices loops through the marked services to determine whether it can start each one. If the service depends on a group that starts later in the group startup sequence than the service’s group, the SCM notes a circular dependency error for the service and doesn’t start the service. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Hi Satya, Thanks for the information you provided. But would like to know how do we set this up or any suggestion how to get this error resolved. Thanks agian,
Anantha

I don’t have ready solution but may try applying the latest service pack to Operating system and check event viewer for any information about services failure during startup. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>