Running SQL Jobs manually

Does anyone know why as a sysadmin I am unable to run jobs
manually? The SQL agent runs under my account and the jobs
run fine on schedule but when I try to run them manually
nothing happens and nothing is logged in Event Viewer.Silly question - Are you refreshing the jobs node to see what activity is
taking place?
Are you gettting any entries under "View job history" for the job you are
trying to run?
--
Simon Worth
"Robert" <anonymous@.discussions.microsoft.com> wrote in message
news:2f7d01c520e0$37410ba0$a501280a@.phx.gbl...
> Does anyone know why as a sysadmin I am unable to run jobs
> manually? The SQL agent runs under my account and the jobs
> run fine on schedule but when I try to run them manually
> nothing happens and nothing is logged in Event Viewer.|||Yes I am refreshing and no there is no history of the
attempts to run manually
>--Original Message--
>Silly question - Are you refreshing the jobs node to see
what activity is
>taking place?
>Are you gettting any entries under "View job history" for
the job you are
>trying to run?
>--
>Simon Worth
>
>"Robert" <anonymous@.discussions.microsoft.com> wrote in
message
>news:2f7d01c520e0$37410ba0$a501280a@.phx.gbl...
>> Does anyone know why as a sysadmin I am unable to run
jobs
>> manually? The SQL agent runs under my account and the
jobs
>> run fine on schedule but when I try to run them manually
>> nothing happens and nothing is logged in Event Viewer.
>
>.
>|||Did you try the stored proc 'sp_start_job' in query analyzer to see what the
output is or any error return values?
--
Simon Worth
<anonymous@.discussions.microsoft.com> wrote in message
news:2fa301c520e2$eb5b63e0$a501280a@.phx.gbl...
> Yes I am refreshing and no there is no history of the
> attempts to run manually
> >--Original Message--
> >Silly question - Are you refreshing the jobs node to see
> what activity is
> >taking place?
> >Are you gettting any entries under "View job history" for
> the job you are
> >trying to run?
> >
> >--
> >Simon Worth
> >
> >
> >"Robert" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:2f7d01c520e0$37410ba0$a501280a@.phx.gbl...
> >> Does anyone know why as a sysadmin I am unable to run
> jobs
> >> manually? The SQL agent runs under my account and the
> jobs
> >> run fine on schedule but when I try to run them manually
> >> nothing happens and nothing is logged in Event Viewer.
> >
> >
> >.
> >|||I ran the job using 'sp_start_job' and the message
said 'starting job successfully'. In EM when I refresh the
job it doesn't appear that the job ran. And I confirmed
that this particular job did not actually run.
>--Original Message--
>Did you try the stored proc 'sp_start_job' in query
analyzer to see what the
>output is or any error return values?
>--
>Simon Worth
>
><anonymous@.discussions.microsoft.com> wrote in message
>news:2fa301c520e2$eb5b63e0$a501280a@.phx.gbl...
>> Yes I am refreshing and no there is no history of the
>> attempts to run manually
>> >--Original Message--
>> >Silly question - Are you refreshing the jobs node to
see
>> what activity is
>> >taking place?
>> >Are you gettting any entries under "View job history"
for
>> the job you are
>> >trying to run?
>> >
>> >--
>> >Simon Worth
>> >
>> >
>> >"Robert" <anonymous@.discussions.microsoft.com> wrote in
>> message
>> >news:2f7d01c520e0$37410ba0$a501280a@.phx.gbl...
>> >> Does anyone know why as a sysadmin I am unable to run
>> jobs
>> >> manually? The SQL agent runs under my account and the
>> jobs
>> >> run fine on schedule but when I try to run them
manually
>> >> nothing happens and nothing is logged in Event
Viewer.
>> >
>> >
>> >.
>> >
>
>.
>|||what about in the SQL Server logs (you said you checked the event viewer
logs), are their any entries in there for failed jobs, or problems starting
jobs?
--
Simon Worth
<anonymous@.discussions.microsoft.com> wrote in message
news:43aa01c520ed$172250b0$a601280a@.phx.gbl...
> I ran the job using 'sp_start_job' and the message
> said 'starting job successfully'. In EM when I refresh the
> job it doesn't appear that the job ran. And I confirmed
> that this particular job did not actually run.
> >--Original Message--
> >Did you try the stored proc 'sp_start_job' in query
> analyzer to see what the
> >output is or any error return values?
> >
> >--
> >Simon Worth
> >
> >
> ><anonymous@.discussions.microsoft.com> wrote in message
> >news:2fa301c520e2$eb5b63e0$a501280a@.phx.gbl...
> >> Yes I am refreshing and no there is no history of the
> >> attempts to run manually
> >> >--Original Message--
> >> >Silly question - Are you refreshing the jobs node to
> see
> >> what activity is
> >> >taking place?
> >> >Are you gettting any entries under "View job history"
> for
> >> the job you are
> >> >trying to run?
> >> >
> >> >--
> >> >Simon Worth
> >> >
> >> >
> >> >"Robert" <anonymous@.discussions.microsoft.com> wrote in
> >> message
> >> >news:2f7d01c520e0$37410ba0$a501280a@.phx.gbl...
> >> >> Does anyone know why as a sysadmin I am unable to run
> >> jobs
> >> >> manually? The SQL agent runs under my account and the
> >> jobs
> >> >> run fine on schedule but when I try to run them
> manually
> >> >> nothing happens and nothing is logged in Event
> Viewer.
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >|||Check the logs for SQL Agent as well to see if there is anything listed in
there.
--
Simon Worth
"Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
news:O21On$OIFHA.3628@.TK2MSFTNGP10.phx.gbl...
> what about in the SQL Server logs (you said you checked the event viewer
> logs), are their any entries in there for failed jobs, or problems
starting
> jobs?
> --
> Simon Worth
>
> <anonymous@.discussions.microsoft.com> wrote in message
> news:43aa01c520ed$172250b0$a601280a@.phx.gbl...
> > I ran the job using 'sp_start_job' and the message
> > said 'starting job successfully'. In EM when I refresh the
> > job it doesn't appear that the job ran. And I confirmed
> > that this particular job did not actually run.
> > >--Original Message--
> > >Did you try the stored proc 'sp_start_job' in query
> > analyzer to see what the
> > >output is or any error return values?
> > >
> > >--
> > >Simon Worth
> > >
> > >
> > ><anonymous@.discussions.microsoft.com> wrote in message
> > >news:2fa301c520e2$eb5b63e0$a501280a@.phx.gbl...
> > >> Yes I am refreshing and no there is no history of the
> > >> attempts to run manually
> > >> >--Original Message--
> > >> >Silly question - Are you refreshing the jobs node to
> > see
> > >> what activity is
> > >> >taking place?
> > >> >Are you gettting any entries under "View job history"
> > for
> > >> the job you are
> > >> >trying to run?
> > >> >
> > >> >--
> > >> >Simon Worth
> > >> >
> > >> >
> > >> >"Robert" <anonymous@.discussions.microsoft.com> wrote in
> > >> message
> > >> >news:2f7d01c520e0$37410ba0$a501280a@.phx.gbl...
> > >> >> Does anyone know why as a sysadmin I am unable to run
> > >> jobs
> > >> >> manually? The SQL agent runs under my account and the
> > >> jobs
> > >> >> run fine on schedule but when I try to run them
> > manually
> > >> >> nothing happens and nothing is logged in Event
> > Viewer.
> > >> >
> > >> >
> > >> >.
> > >> >
> > >
> > >
> > >.
> > >
>|||i did see one entry for my logon. Error: 15457, Severity:
0, State: 1
Configuration option 'show advanced options' changed from
1 to 1. Run the RECONFIGURE statement to install.
Do you know what this means?
>--Original Message--
>Check the logs for SQL Agent as well to see if there is
anything listed in
>there.
>--
>Simon Worth
>
>"Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote
in message
>news:O21On$OIFHA.3628@.TK2MSFTNGP10.phx.gbl...
>> what about in the SQL Server logs (you said you checked
the event viewer
>> logs), are their any entries in there for failed jobs,
or problems
>starting
>> jobs?
>> --
>> Simon Worth
>>
>> <anonymous@.discussions.microsoft.com> wrote in message
>> news:43aa01c520ed$172250b0$a601280a@.phx.gbl...
>> > I ran the job using 'sp_start_job' and the message
>> > said 'starting job successfully'. In EM when I
refresh the
>> > job it doesn't appear that the job ran. And I
confirmed
>> > that this particular job did not actually run.
>> > >--Original Message--
>> > >Did you try the stored proc 'sp_start_job' in query
>> > analyzer to see what the
>> > >output is or any error return values?
>> > >
>> > >--
>> > >Simon Worth
>> > >
>> > >
>> > ><anonymous@.discussions.microsoft.com> wrote in
message
>> > >news:2fa301c520e2$eb5b63e0$a501280a@.phx.gbl...
>> > >> Yes I am refreshing and no there is no history of
the
>> > >> attempts to run manually
>> > >> >--Original Message--
>> > >> >Silly question - Are you refreshing the jobs node
to
>> > see
>> > >> what activity is
>> > >> >taking place?
>> > >> >Are you gettting any entries under "View job
history"
>> > for
>> > >> the job you are
>> > >> >trying to run?
>> > >> >
>> > >> >--
>> > >> >Simon Worth
>> > >> >
>> > >> >
>> > >> >"Robert" <anonymous@.discussions.microsoft.com>
wrote in
>> > >> message
>> > >> >news:2f7d01c520e0$37410ba0$a501280a@.phx.gbl...
>> > >> >> Does anyone know why as a sysadmin I am unable
to run
>> > >> jobs
>> > >> >> manually? The SQL agent runs under my account
and the
>> > >> jobs
>> > >> >> run fine on schedule but when I try to run them
>> > manually
>> > >> >> nothing happens and nothing is logged in Event
>> > Viewer.
>> > >> >
>> > >> >
>> > >> >.
>> > >> >
>> > >
>> > >
>> > >.
>> > >
>>
>
>.
>