<div>
Thanks - and I was looking for some complicated way of using xp_servicecontrol or something...<br />
<br />
cheers.
</div>


Thanks - and I was looking for some complicated way of using xp_servicecontrol or something...

cheers.

<div>
<div class="content wysiwyg-content">
I was hoping someone may have some advice for how I can ensure the SQL Server Agent starts automatically with SQL Server 2000.<br />
<br />
I have some scheduled jobs that must run and on a couple of occasions I have been stung by the agent not starting after a reboot of the PC.<br />
<br />
Any advice is much appreciated.
</div>
</div>


I was hoping someone may have some advice for how I can ensure the SQL Server Agent starts automatically with SQL Server 2000.

I have some scheduled jobs that must run and on a couple of occasions I have been stung by the agent not starting after a reboot of the PC.

Any advice is much appreciated.

SQL Server Agent - Autostart

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.