Link to home
Start Free TrialLog in
Avatar of GlobaLevel
GlobaLevelFlag for United States of America

asked on

ms sql server 2005 - job schedule isnt working....

I created a job to run automatically on the SQL Server agent...but when I look at the
Job activity monitor...the job hasnt run...do I have to have sql authentication or can I do it under localhost...in windows...
Avatar of JoeNuvo
JoeNuvo
Flag of Viet Nam image

few thing to check

1. Does job already define Schedule?
2. Does Schedule timing is valid?
3. Does Schedule enabled?
4. Does Job itself enabled?
5. Does SQL Agent Started?
ASKER CERTIFIED SOLUTION
Avatar of ShawnRazor
ShawnRazor
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
However, I was once experience the problem that, the job is not run on defined schedule.
Still don't know reason, but I fix it by delete and recreate the job.
Avatar of Umesh_Madap
Umesh_Madap

Hi,
After creating the job you have to schedule the job, please check it when it is scheduled.

if it is not scheduled then schedule the job and verify it is successful or not.
Avatar of GlobaLevel

ASKER

Right click and run the job manually , try if there is an error.
>>tried that...I get the bid red 'X'...saying that it doent see it...