Hi,
I try to activate on my new dev server "data collection" feature.
Oddly it gives me error. I have already defined a server/db where I collect data and already in other db instancesi it's up and running.
While trying to activate no job was created.
I'm logged like sysadmin with my domain user naturally and also tried with sql server (sysadmin user)
This is the error:
===================================
Unable to start collection set Disk Usage. (Microsoft.SqlServer.Management.Collector)
------------------------------
For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=16.100.47008.0&LinkId=20476
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Collector.CollectionSet.StartStopUpload(String script, Boolean modifyIsRunning, Boolean isRunningVal, String exptnString)
at Microsoft.SqlServer.Management.Collector.CollectionSet.Start()
at Microsoft.SqlServer.Management.SqlManagerUI.StartDataCollectionSet.StartDataCollectionSetAction.DoAction(ProgressItemCollection actions, Int32 index)
at Microsoft.SqlServer.Management.SqlStudio.Controls.ProgressItemCollection.DoWorkOnThread()
===================================
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType, Boolean retry)
at Microsoft.SqlServer.Management.Collector.CollectionSet.StartStopUpload(String script, Boolean modifyIsRunning, Boolean isRunningVal, String exptnString)
===================================
Caught error#: 14373, Level: 16, State: 1, in Procedure: sp_verify_schedule_identifiers, Line: 29, with Message: Supply either @schedule_id or @schedule_name to identify the schedule. (.Net SqlClient Data Provider)
------------------------------
For help, click: https://learn.microsoft.com/sql/relational-databases/errors-events/mssqlserver-14684-database-engine-error
------------------------------
Server Name: XXXXXXXXXX
Error Number: 14684
Severity: 16
State: 1
Procedure: msdb.dbo.sp_syscollector_start_collection_set
Line Number: 203
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType, Boolean retry)
Do you have any idea what the cause might be?
ALEN