Schedule Job is not running?

I schedule a job to run every day at 1:00 am and it should notify me by email
on complete. Next day i did not receive email and job did not run.
If i start a job manually then i don't have any problem.
Why job is not running automatically?
Please let me know whar i need to do to make this work.
Thank you."JT" <JT@.discussions.microsoft.com> wrote in message
news:BFEC7795-869C-4ECB-89FE-9D7C3618C2B9@.microsoft.com...
>I schedule a job to run every day at 1:00 am and it should notify me by
>email
> on complete. Next day i did not receive email and job did not run.
> If i start a job manually then i don't have any problem.
> Why job is not running automatically?
> Please let me know whar i need to do to make this work.
> Thank you.
>
A couple of things.
1. Ensure that the job is enabled.
2. Ensure that the SQL Server Agent Service is running.
3. Ensure that the job owner has the appropriate permissions on all objects
contained in the job steps.
HTH
Rick Sawtell|||JT,
Please check that both the job and the job schedule are enabled. I have
seen cases where only one of the two was enabled, doubtless through a simple
oversight.
If something is disabled, that only prevents the scheduler from running the
job. You can still run it manually.
RLF
"JT" <JT@.discussions.microsoft.com> wrote in message
news:BFEC7795-869C-4ECB-89FE-9D7C3618C2B9@.microsoft.com...
>I schedule a job to run every day at 1:00 am and it should notify me by
>email
> on complete. Next day i did not receive email and job did not run.
> If i start a job manually then i don't have any problem.
> Why job is not running automatically?
> Please let me know whar i need to do to make this work.
> Thank you.
>|||In addition to Russell's advice, check the history for the job, and see if
it ran and failed, and if so, the reason for the failure. I am not clear if
you have determined that the job did not run, or that the ultimate result of
the job running was not accomplished.
A
"JT" <JT@.discussions.microsoft.com> wrote in message
news:BFEC7795-869C-4ECB-89FE-9D7C3618C2B9@.microsoft.com...
>I schedule a job to run every day at 1:00 am and it should notify me by
>email
> on complete. Next day i did not receive email and job did not run.
> If i start a job manually then i don't have any problem.
> Why job is not running automatically?
> Please let me know whar i need to do to make this work.
> Thank you.
>|||I checked all these steps.
Yes, the job and the job schedule are enabled.
The SQL Server Agent Service is running.
3. Ensure that the job owner has the appropriate permissions on all objects
contained in the job steps. What exactly do i need to check?
Also I checked the history does not show anything. Basically it did not run
at scheduled time at all.
"Aaron Bertrand [SQL Server MVP]" wrote:
> In addition to Russell's advice, check the history for the job, and see if
> it ran and failed, and if so, the reason for the failure. I am not clear if
> you have determined that the job did not run, or that the ultimate result of
> the job running was not accomplished.
> A
>
> "JT" <JT@.discussions.microsoft.com> wrote in message
> news:BFEC7795-869C-4ECB-89FE-9D7C3618C2B9@.microsoft.com...
> >I schedule a job to run every day at 1:00 am and it should notify me by
> >email
> > on complete. Next day i did not receive email and job did not run.
> >
> > If i start a job manually then i don't have any problem.
> >
> > Why job is not running automatically?
> > Please let me know whar i need to do to make this work.
> >
> > Thank you.
> >
>
>|||JT,
I assume that other jobs are running successfully, but if no jobs are
running please say so. The only other thing that comes to mind is if the
schedule start and end date window is outside the current time. For
example: the job is set to first execute on January 10, 2009. Et cetera.
RLF
"JT" <JT@.discussions.microsoft.com> wrote in message
news:12A56E0C-7F0F-48E2-92CE-C26BE46E7019@.microsoft.com...
>I checked all these steps.
> Yes, the job and the job schedule are enabled.
> The SQL Server Agent Service is running.
> 3. Ensure that the job owner has the appropriate permissions on all
> objects
> contained in the job steps. What exactly do i need to check?
> Also I checked the history does not show anything. Basically it did not
> run
> at scheduled time at all.
>
> "Aaron Bertrand [SQL Server MVP]" wrote:
>> In addition to Russell's advice, check the history for the job, and see
>> if
>> it ran and failed, and if so, the reason for the failure. I am not clear
>> if
>> you have determined that the job did not run, or that the ultimate result
>> of
>> the job running was not accomplished.
>> A
>>
>> "JT" <JT@.discussions.microsoft.com> wrote in message
>> news:BFEC7795-869C-4ECB-89FE-9D7C3618C2B9@.microsoft.com...
>> >I schedule a job to run every day at 1:00 am and it should notify me by
>> >email
>> > on complete. Next day i did not receive email and job did not run.
>> >
>> > If i start a job manually then i don't have any problem.
>> >
>> > Why job is not running automatically?
>> > Please let me know whar i need to do to make this work.
>> >
>> > Thank you.
>> >
>>