SQL Task Scheduler for 6.5 not running.

[Maxxamillian]

Scheduled backup for one of our SQL 6.5 DB Task Scheduler not working.  Logs reveal nothing.  History is showing that the task did not even begin.  If the server is rebooted then the scheduler will work one time and that is it. (Will perform all tasks within assigned time after reboot once.)  This is bizzare...any tips??

 

[clawton]

This is for SQL Server 7.0, not 6.5, but the information may be helpful :<br><br>I installed SQL Server 7 on a server with SQL Server ODBC server drivers Vsn 2.65 already installed.&nbsp;&nbsp;The installed of SQL Server went without error, however SQL Server Agent would not run.<br><br>It turns out that SQL Server required MDAC 2.1 ODBC Drivers (Version 3 and above) to run.&nbsp;&nbsp;These were not installed as part of the SQ Server installation.&nbsp;&nbsp;It eventually needed a manual copy of the relevent DLL's into the System directory.<br><br>To sum up then, check the version of your ODBC drivers, and upgrade to version 3 if necessary.<br><br>Only a hunch, but worth a try.<br><br>Chris.<br><br>

 

[nikhilmehrotra]

HI, <br>Check whether the msdb database exists or not(this database handles all the scheduled tasks). The problem could be because of that also. If it exists check for the stored procedure that manages the tasks in the msdb database.