My SQL Agent was working fine. Now when I try to run it, it failes when trying to run my SSIS package. I looked in the logs, and job history, no luck in finding any critical errors.
My SSIS package runs fine through VS 2005 in debug mode.
Here are the only errors:
01/04/2006 09:53:48,,Warning, An idle CPU condition has not been defined - OnIdle job schedules will have no effect01/04/2006 09:53:48,,Warning, Unable to start mail session (reason: No mail profile defined)01/04/2006 09:53:48,,Information, SQLSERVERAGENT starting under Windows NT service control01/04/2006 09:53:48,,Error, The Messenger service has not been started - NetSend notifications will not be sent01/04/2006 09:53:30,,Information, There are 11 subsystems in the subsystems cache01/04/2006 09:53:29,,Information, Local computer is BG-SQL2005 running Windows NT 5.2 (3790) Service Pack 101/04/2006 09:53:29,,Information, 1 processor(s) and 512 MB RAM detected01/04/2006 09:53:29,,Information, NetLib being used by driver is DBNETLIB.DLL; Local host server is01/04/2006 09:53:29,,Information, SQL Server ODBC driver version 9.00.139901/04/2006 09:53:29,,Information, SQL Server BG-SQL2005 version 9.00.1399 (0 connection limit)01/04/2006 09:53:29,,Information, Microsoft SQLServerAgent version 9.00.1399.06 (x86 unicode retail build) : Process ID 1860
View Complete Post