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...
LVL 10
GlobaLevelProgrammerAsked:
Who is Participating?
 
ShawnRazorConnect With a Mentor Commented:
Right click and run the job manually , try if there is an error.
0
 
JoeNuvoCommented:
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?
0
 
JoeNuvoCommented:
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.
0
 
Umesh_MadapCommented:
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.
0
 
GlobaLevelProgrammerAuthor Commented:
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...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.