GlobaLevel
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...
Job activity monitor...the job hasnt run...do I have to have sql authentication or can I do it under localhost...in windows...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
Still don't know reason, but I fix it by delete and recreate the job.
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.
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.
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...
>>tried that...I get the bid red 'X'...saying that it doent see it...
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?