maintanence plan fails - Adding job step

I am trying to create a new maint plan on a dev server and it fails to create
it. It is failing when attempting to add the job steps to the agent. I have
performed this on two other dev server without any issues. I verified all
the settings, configurations, protocols, proxies, and logins are configured
the same on all servers.
The other servers taht this is working on do not have any special proxy
settings and I tried to create a new connection and used the "local
connection" settings. None will work.
Here is the tech details from the error it is generating. Any help will be
appreciated.
===================================
Create maintenance plan failed.
===================================
Create failed for JobStep 'Subplan'.
(Microsoft.SqlServer.MaintenancePlanTasks)
For help, click:
http://go.microsoft.com/fwlink?ProdN...p&LinkId=20476
Program Location:
at
Microsoft.SqlServer.Management.DatabaseMaintenance .MaintenancePlanSubPlan.AddAgentJob(ServerConnecti on localConnObj, String proxyName)
at
Microsoft.SqlServer.Management.DatabaseMaintenance .MaintenancePlanSubPlan..ctor(String
subplanName, String proxyAccount, Package package, ServerConnection
localConnObj)
at
Microsoft.SqlServer.Management.DatabaseMaintenance .MaintenancePlan.AddSubPlan(String subplanName, String proxyAccount)
at
Microsoft.SqlServer.Management.MaintenancePlanWiza rd.MaintenancePlanWizardForm.PerformActions()
===================================
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
Program Location:
at
Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(String
sqlCommand, ExecutionTypes executionType)
at
Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
at
Microsoft.SqlServer.Management.Smo.ExecutionManage r.ExecuteNonQuery(StringCollection queries)
at
Microsoft.SqlServer.Management.Smo.SqlSmoObject.Ex ecuteNonQuery(StringCollection queries, Boolean includeDbContext)
at
Microsoft.SqlServer.Management.Smo.SqlSmoObject.Cr eateImplFinish(StringCollection createQuery, ScriptingOptions so)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Cr eateImpl()
===================================
The specified '@.subsystem' is invalid (valid values are returned by
sp_enum_sqlagent_subsystems). (.Net SqlClient Data Provider)
For help, click:
http://go.microsoft.com/fwlink?ProdN...4&LinkId=20476
Server Name: TST-TFS2005\TSTTFS2005,1450
Error Number: 14234
Severity: 16
State: 1
Procedure: sp_verify_subsystem
Line Number: 28
Program Location:
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQuer yTds(String
methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at
Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(String
sqlCommand, ExecutionTypes executionType)
Stan
This error generally means that SSIS is not installed on the server. This is
required for the new style maintenance plans in SQL2005. Can you confirm
whether Integration Services is installed on the server you are seeing the
error on.
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Stan" <Stan@.discussions.microsoft.com> wrote in message
news:696C7781-51A5-4B4E-9595-9AA307ECA806@.microsoft.com...
>I am trying to create a new maint plan on a dev server and it fails to
>create
> it. It is failing when attempting to add the job steps to the agent. I
> have
> performed this on two other dev server without any issues. I verified all
> the settings, configurations, protocols, proxies, and logins are
> configured
> the same on all servers.
> The other servers taht this is working on do not have any special proxy
> settings and I tried to create a new connection and used the "local
> connection" settings. None will work.
> Here is the tech details from the error it is generating. Any help will
> be
> appreciated.
>
> ===================================
> Create maintenance plan failed.
> ===================================
> Create failed for JobStep 'Subplan'.
> (Microsoft.SqlServer.MaintenancePlanTasks)
> --
> For help, click:
> http://go.microsoft.com/fwlink?ProdN...p&LinkId=20476
> --
> Program Location:
> at
> Microsoft.SqlServer.Management.DatabaseMaintenance .MaintenancePlanSubPlan.AddAgentJob(ServerConnecti on
> localConnObj, String proxyName)
> at
> Microsoft.SqlServer.Management.DatabaseMaintenance .MaintenancePlanSubPlan..ctor(String
> subplanName, String proxyAccount, Package package, ServerConnection
> localConnObj)
> at
> Microsoft.SqlServer.Management.DatabaseMaintenance .MaintenancePlan.AddSubPlan(String
> subplanName, String proxyAccount)
> at
> Microsoft.SqlServer.Management.MaintenancePlanWiza rd.MaintenancePlanWizardForm.PerformActions()
> ===================================
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> Program Location:
> at
> Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(String
> sqlCommand, ExecutionTypes executionType)
> at
> Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(StringCollection
> sqlCommands, ExecutionTypes executionType)
> at
> Microsoft.SqlServer.Management.Smo.ExecutionManage r.ExecuteNonQuery(StringCollection
> queries)
> at
> Microsoft.SqlServer.Management.Smo.SqlSmoObject.Ex ecuteNonQuery(StringCollection
> queries, Boolean includeDbContext)
> at
> Microsoft.SqlServer.Management.Smo.SqlSmoObject.Cr eateImplFinish(StringCollection
> createQuery, ScriptingOptions so)
> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Cr eateImpl()
> ===================================
> The specified '@.subsystem' is invalid (valid values are returned by
> sp_enum_sqlagent_subsystems). (.Net SqlClient Data Provider)
> --
> For help, click:
> http://go.microsoft.com/fwlink?ProdN...4&LinkId=20476
> --
> Server Name: TST-TFS2005\TSTTFS2005,1450
> Error Number: 14234
> Severity: 16
> State: 1
> Procedure: sp_verify_subsystem
> Line Number: 28
>
> --
> Program Location:
> at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
> Boolean breakConnection)
> at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
> exception, Boolean breakConnection)
> at
> System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
> stateObj)
> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
> bulkCopyHandler, TdsParserStateObject stateObj)
> at System.Data.SqlClient.SqlCommand.RunExecuteNonQuer yTds(String
> methodName, Boolean async)
> at
> System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult
> result, String methodName, Boolean sendToPipe)
> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
> at
> Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(String
> sqlCommand, ExecutionTypes executionType)
>
> --
> Stan

maint. plan fails but doenst report error

Hello

I have this maint. plan where each and every step has been failing the last couple of days. The problem is, it doesn't write anything to the error logs. It only reports to the application log that each step of the plan has failed.

I suspect this might be a user rights problem, but it's difficult for me to say. What kind of rights are necessary for writing to the error logs?

In general, what rights are necessary for the user that runs the SQL Server Agent? And has anybody else experienced something similar?

MNJThis is mostly about scheduling a DTS package as a job. However, the security aspect of it should pertain to your situation as well.

Go Here: http://support.microsoft.com/default.aspx?scid=kb;en-us;269074 (Microsoft Knowledge Base Article 269074)

Mailsend program

Hi All,

I have installed SQL Server 2005 and created a job. I made the job failed to test the mailsend program. The notification step that uses the mailsend succeeded but I did not get an email. I am using mailsend program on SQL Server 2000 and it works fine. I am really stomped and don't know what to do to fix it?

Thanks.what are you using to send mail? xp_sendmail? xp_smtpmail? CDOSYS? CDONTS?

I feel stomped everyday.|||I am using xp_sendmail.|||have you...

installed outlook on your DB server?

is the agent using a network account mapped to an exhange mail profile?

have you tested sending mail directly from the mail client?

have you started a sql mail client session with xp_startmail?|||Yes, Outlook Express

How can I check it? Our network guys set up the server

Yes and it was successfull

I have read in BOL that this feature will be removed in a future version of Microsoft SQL Server.|||Have you opened the "Surface Area Configuration" tool and looked under feature configuration to enable SQL Mail?

BTW ... Database Mail is the preferred method with 2005.|||I'll try Database Mail option|||Database Mail is MUCH better. It takes a bit of configuration, but it's really nice.

hmscott|||On SQL Server 2005 use sp_senddbmail. It sends mail using SMTP and uses service broker for queuing mails to be sent. No need for Outlook on the server anymore, and the mail sending process is 100% asyncronous.

Mailing labels for dummies

Ok, I'm an idiot. Does anyone out there have some step by step instructions for creating a report that will do mailing labels. I've got multiple columns on my report but I end up with the contents of each column being the same across each grouping/row. In other words for each record read, since I have three columns, I get three occurances of each customer and address until all the data selected for that row is presented, then I go to the next customer which again is repeated across all three columns.

I'm sorry I'm so stupid, but I've looked at other entries on the forum, and I just can't figure it out. We are trying to get out from underneith Business objects thumb and any help would be greatly appreciated. Thanks! - Eric -

Carpet King,

I think what you are looking for is the Multiple Column type report. you will set this up by using going into the report properties and setting the number of colums to 3.

Hope this helps

|||

Thanks Bret for the input. Your posting helped me to figure out where to look and change the properties. It through me for a while 'cause the pre-view doesn't show the multiple columns. As a result, after reading your input and making the change, it took a while to figure out that what you told me to do really did fix the problem.

The SQL reporting services is still Marginal (at best!) in creating labels. I'm having a heck of a time getting things evened out so that they will print on my labels correctly. I'm still having a lot of problems getting it set up just right so that information from one label doesn't carry over to another.

None the less, thank you very much for your help! I don't want you to feel like I am shooting the messanger, just venting. Sorry. :B - Eric -

|||

Hello,

I am working on mailing labels and I have the 3 columns, but now I am trying to get them to print across the page,rather than down the page. (Trying to prevent wasting labels by going down the page.) Below is an example of what I need:

1 2 3 4

NOT

1

2

3

4

Any ideas would be greatly appreciated!

mbsqlnewbie

Mailing labels for dummies

Ok, I'm an idiot. Does anyone out there have some step by step instructions for creating a report that will do mailing labels. I've got multiple columns on my report but I end up with the contents of each column being the same across each grouping/row. In other words for each record read, since I have three columns, I get three occurances of each customer and address until all the data selected for that row is presented, then I go to the next customer which again is repeated across all three columns.

I'm sorry I'm so stupid, but I've looked at other entries on the forum, and I just can't figure it out. We are trying to get out from underneith Business objects thumb and any help would be greatly appreciated. Thanks! - Eric -

Carpet King,

I think what you are looking for is the Multiple Column type report. you will set this up by using going into the report properties and setting the number of colums to 3.

Hope this helps

|||

Thanks Bret for the input. Your posting helped me to figure out where to look and change the properties. It through me for a while 'cause the pre-view doesn't show the multiple columns. As a result, after reading your input and making the change, it took a while to figure out that what you told me to do really did fix the problem.

The SQL reporting services is still Marginal (at best!) in creating labels. I'm having a heck of a time getting things evened out so that they will print on my labels correctly. I'm still having a lot of problems getting it set up just right so that information from one label doesn't carry over to another.

None the less, thank you very much for your help! I don't want you to feel like I am shooting the messanger, just venting. Sorry. :B - Eric -

|||

Hello,

I am working on mailing labels and I have the 3 columns, but now I am trying to get them to print across the page,rather than down the page. (Trying to prevent wasting labels by going down the page.) Below is an example of what I need:

1 2 3 4

NOT

1

2

3

4

Any ideas would be greatly appreciated!

mbsqlnewbie

Mail service Error

I have a SQL Server 2000 with Service Pack 3. I have job
that is hung on a step that tries to stop the mail (using
xp_stopmail command) service. The Status says Executing
for the last day.
What could cause the mail service to not be able to stop
when using xp_stopmail or not to start when using
xp_sendmail?
Also, how can I reset this without restarting the server?
I had the same issue a few weeks ago and tried to stop the
mail service but couldn't
I then tried to stop the Agent, thinking restarting the
agent would release the lock. But then the agent wouldn't
restart, so I had to restart the Server to get things
working.
Thanks
DonHave seen the exact same problem occasionally before. The problem was only
fixed after restart SQL server. It was likely caused by problems on the
Exchange server side.
Richard
"Don" <dons100@.yahoo.com> wrote in message
news:4ce701c3ffc1$ac2df590$a401280a@.phx.gbl...
> I have a SQL Server 2000 with Service Pack 3. I have job
> that is hung on a step that tries to stop the mail (using
> xp_stopmail command) service. The Status says Executing
> for the last day.
> What could cause the mail service to not be able to stop
> when using xp_stopmail or not to start when using
> xp_sendmail?
> Also, how can I reset this without restarting the server?
> I had the same issue a few weeks ago and tried to stop the
> mail service but couldn't
> I then tried to stop the Agent, thinking restarting the
> agent would release the lock. But then the agent wouldn't
> restart, so I had to restart the Server to get things
> working.
> Thanks
> Don

Mail service Error

I have a SQL Server 2000 with Service Pack 3. I have job
that is hung on a step that tries to stop the mail (using
xp_stopmail command) service. The Status says Executing
for the last day.
What could cause the mail service to not be able to stop
when using xp_stopmail or not to start when using
xp_sendmail?
Also, how can I reset this without restarting the server?
I had the same issue a few weeks ago and tried to stop the
mail service but couldn't
I then tried to stop the Agent, thinking restarting the
agent would release the lock. But then the agent wouldn't
restart, so I had to restart the Server to get things
working.
Thanks
DonHave seen the exact same problem occasionally before. The problem was only
fixed after restart SQL server. It was likely caused by problems on the
Exchange server side.
Richard
"Don" <dons100@.yahoo.com> wrote in message
news:4ce701c3ffc1$ac2df590$a401280a@.phx.gbl...
> I have a SQL Server 2000 with Service Pack 3. I have job
> that is hung on a step that tries to stop the mail (using
> xp_stopmail command) service. The Status says Executing
> for the last day.
> What could cause the mail service to not be able to stop
> when using xp_stopmail or not to start when using
> xp_sendmail?
> Also, how can I reset this without restarting the server?
> I had the same issue a few weeks ago and tried to stop the
> mail service but couldn't
> I then tried to stop the Agent, thinking restarting the
> agent would release the lock. But then the agent wouldn't
> restart, so I had to restart the Server to get things
> working.
> Thanks
> Don