Wednesday, March 7, 2012

Schedule Job is not running?

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...[vbcol=seagreen]
>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:

No comments:

Post a Comment