maint plan with syntax error from wizard

Hello,
I have created a fairly full-blown maint plan for a number of databases on
sql server standard 2005. The plan includes backup, index maintenance,
shrink, and a few other things I can't recall. This plan was created with
the maintenance wizard. When I try to run it I get a syntax error and in
viewing the generated t-sql I really don't see any problems with it. Has
anyone encountered this and what is the likely issue here? I guess I'm
implying that I don't really believe the error message since I don't believe
the wizard could really create a syntax error. Any help with this would be
greatly appreciated.
Thanks, NWOP.What is the T-SQL statement and the error messages?
By the way running shrink statements in your jobs and maintenance plan is
not a good idea and could impact the performance of your server.
Hope this helps,
Ben Nevarez
"new_world_order_pigs" wrote:
> Hello,
> I have created a fairly full-blown maint plan for a number of databases on
> sql server standard 2005. The plan includes backup, index maintenance,
> shrink, and a few other things I can't recall. This plan was created with
> the maintenance wizard. When I try to run it I get a syntax error and in
> viewing the generated t-sql I really don't see any problems with it. Has
> anyone encountered this and what is the likely issue here? I guess I'm
> implying that I don't really believe the error message since I don't believe
> the wizard could really create a syntax error. Any help with this would be
> greatly appreciated.
> Thanks, NWOP.|||Wow, you responded before the original showed up in the page. Thanks. The
only error message at all is "syntax error" and something along the lines of
job couldn't start. The only way I know to see the syntax is to "edit" the
step and click "show t-sql"-- if there is another way I'd like to know it and
also, if there are further error messages to look at I'd like to know that as
well.
Thanks again Ben,
NWOP.
"Ben Nevarez" wrote:
> What is the T-SQL statement and the error messages?
> By the way running shrink statements in your jobs and maintenance plan is
> not a good idea and could impact the performance of your server.
> Hope this helps,
> Ben Nevarez
>
>
> "new_world_order_pigs" wrote:
> > Hello,
> >
> > I have created a fairly full-blown maint plan for a number of databases on
> > sql server standard 2005. The plan includes backup, index maintenance,
> > shrink, and a few other things I can't recall. This plan was created with
> > the maintenance wizard. When I try to run it I get a syntax error and in
> > viewing the generated t-sql I really don't see any problems with it. Has
> > anyone encountered this and what is the likely issue here? I guess I'm
> > implying that I don't really believe the error message since I don't believe
> > the wizard could really create a syntax error. Any help with this would be
> > greatly appreciated.
> > Thanks, NWOP.|||If you have a problem with a job, select View History, expand the steps of
your job and look for error messages there. Also, some T-SQL statements write
entries to the SQL Server error log, so look for errors there as well.
Hope this helps,
Ben Nevarez
"new_world_order_pigs" wrote:
> Wow, you responded before the original showed up in the page. Thanks. The
> only error message at all is "syntax error" and something along the lines of
> job couldn't start. The only way I know to see the syntax is to "edit" the
> step and click "show t-sql"-- if there is another way I'd like to know it and
> also, if there are further error messages to look at I'd like to know that as
> well.
> Thanks again Ben,
> NWOP.
> "Ben Nevarez" wrote:
> >
> > What is the T-SQL statement and the error messages?
> >
> > By the way running shrink statements in your jobs and maintenance plan is
> > not a good idea and could impact the performance of your server.
> >
> > Hope this helps,
> >
> > Ben Nevarez
> >
> >
> >
> >
> > "new_world_order_pigs" wrote:
> >
> > > Hello,
> > >
> > > I have created a fairly full-blown maint plan for a number of databases on
> > > sql server standard 2005. The plan includes backup, index maintenance,
> > > shrink, and a few other things I can't recall. This plan was created with
> > > the maintenance wizard. When I try to run it I get a syntax error and in
> > > viewing the generated t-sql I really don't see any problems with it. Has
> > > anyone encountered this and what is the likely issue here? I guess I'm
> > > implying that I don't really believe the error message since I don't believe
> > > the wizard could really create a syntax error. Any help with this would be
> > > greatly appreciated.
> > > Thanks, NWOP.|||Ben Nevarez wrote:
> If you have a problem with a job, select View History, expand the steps of
> your job and look for error messages there. Also, some T-SQL statements write
> entries to the SQL Server error log, so look for errors there as well.
> Hope this helps,
> Ben Nevarez
>
>
> "new_world_order_pigs" wrote:
>
>> Wow, you responded before the original showed up in the page. Thanks. The
>> only error message at all is "syntax error" and something along the lines of
>> job couldn't start. The only way I know to see the syntax is to "edit" the
>> step and click "show t-sql"-- if there is another way I'd like to know it and
>> also, if there are further error messages to look at I'd like to know that as
>> well.
>> Thanks again Ben,
>> NWOP.
>> "Ben Nevarez" wrote:
>>
>> What is the T-SQL statement and the error messages?
>> By the way running shrink statements in your jobs and maintenance plan is
>> not a good idea and could impact the performance of your server.
>> Hope this helps,
>> Ben Nevarez
>>
>>
>> "new_world_order_pigs" wrote:
>>
>> Hello,
>> I have created a fairly full-blown maint plan for a number of databases on
>> sql server standard 2005. The plan includes backup, index maintenance,
>> shrink, and a few other things I can't recall. This plan was created with
>> the maintenance wizard. When I try to run it I get a syntax error and in
>> viewing the generated t-sql I really don't see any problems with it. Has
>> anyone encountered this and what is the likely issue here? I guess I'm
>> implying that I don't really believe the error message since I don't believe
>> the wizard could really create a syntax error. Any help with this would be
>> greatly appreciated.
>> Thanks, NWOP.
Since this is a maintenance plan - right click on the maintenance plan
and view history instead of the agent job. This history will show you
each step in your maintenance plan and give you more information about
what exactly is failing.|||Hello again and thanks for all the assistance. I have now done all of these
things and actually taken each and every step separately, viewed the t-sql,
executed it step by step and get a success on each one. So, I'm thinking it
must be something having to do with the manner in which it is evoked. I
guess I'm still surprised this isn't a common and recognizeable problem since
I've never believed that I'm "so special." In any case, where would I look
to see how the job itself is being invoked? Perhaps that is it? Perhaps I'm
missing something?
Thanks again,
NWOP.
"Jeffrey Williams" wrote:
> Ben Nevarez wrote:
> > If you have a problem with a job, select View History, expand the steps of
> > your job and look for error messages there. Also, some T-SQL statements write
> > entries to the SQL Server error log, so look for errors there as well.
> >
> > Hope this helps,
> >
> > Ben Nevarez
> >
> >
> >
> >
> > "new_world_order_pigs" wrote:
> >
> >
> >> Wow, you responded before the original showed up in the page. Thanks. The
> >> only error message at all is "syntax error" and something along the lines of
> >> job couldn't start. The only way I know to see the syntax is to "edit" the
> >> step and click "show t-sql"-- if there is another way I'd like to know it and
> >> also, if there are further error messages to look at I'd like to know that as
> >> well.
> >>
> >> Thanks again Ben,
> >> NWOP.
> >>
> >> "Ben Nevarez" wrote:
> >>
> >>
> >> What is the T-SQL statement and the error messages?
> >>
> >> By the way running shrink statements in your jobs and maintenance plan is
> >> not a good idea and could impact the performance of your server.
> >>
> >> Hope this helps,
> >>
> >> Ben Nevarez
> >>
> >>
> >>
> >>
> >> "new_world_order_pigs" wrote:
> >>
> >>
> >> Hello,
> >>
> >> I have created a fairly full-blown maint plan for a number of databases on
> >> sql server standard 2005. The plan includes backup, index maintenance,
> >> shrink, and a few other things I can't recall. This plan was created with
> >> the maintenance wizard. When I try to run it I get a syntax error and in
> >> viewing the generated t-sql I really don't see any problems with it. Has
> >> anyone encountered this and what is the likely issue here? I guess I'm
> >> implying that I don't really believe the error message since I don't believe
> >> the wizard could really create a syntax error. Any help with this would be
> >> greatly appreciated.
> >> Thanks, NWOP.
> >>
> Since this is a maintenance plan - right click on the maintenance plan
> and view history instead of the agent job. This history will show you
> each step in your maintenance plan and give you more information about
> what exactly is failing.
>