Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Soumen Dey
Starting Member
20 Posts |
 Posted - 2005-02-23 : 02:52:50
|
| Hi,I 've scheduled a job and it is not working. Some thing is wrong with the SQL SERVER AGENT Service.I've restarted the service, but still the scheduled jobs are not running on time. Is there any way to reinstall the sqlserver agent service. Log files shows that it is a a problem which is Operating system related. I'm running sql server 2000 on windows 2000 platform.Please helpSoumen |
|
|
CanadaDBA
583 Posts |
Posted - 2005-02-23 : 08:14:43
|
| ...but still the scheduled jobs are not running on timeSo, they run but not on the time you want, right? Or they don't run at all?Have you ensured the SQL-Server AGENT is running? You can check the SQLSERVERAGENT service under Services in Administrative Tools. Also, you may check log on info in there.Canada DBA |
 |
|
|
Soumen Dey
Starting Member
20 Posts |
Posted - 2005-02-23 : 23:18:16
|
| No, the scheduler is not running at all. As a result I 'm having sleepless nights taking database backup manually. I've checked the services it is running but there is no effect.Is there any way of reinstalling the service. |
|
|
|
CanadaDBA
583 Posts |
Posted - 2005-02-24 : 08:40:58
|
1. Can you check the log on user id for the SQLSERVERAGENT service and let me know if it has enough rights to run the jobs.2. Are the jobs enabled? In EM, double Click on a job and note if there is a check mark for Enabled. Also, under Schedule click Edit and see if there is a check mark for Enabled, as well. 3. Have you setup SP3 on the SQL-Server? quote:
Originally posted by Soumen Dey
No, the scheduler is not running at all. As a result I 'm having sleepless nights taking database backup manually. I've checked the services it is running but there is no effect.Is there any way of reinstalling the service.
Canada DBA |
|
|
|
|
|
|
Scheduled job not working