Devart Forums

Is there a way to view, alter and create SQL jobs within dbForge Studio? Along that note how can server objects such as linked servers be viewed, altered and created within dbForge Studio?

Thanks

Is there a way to view, alter and create SQL jobs within dbForge Studio?

There is no such functionality in dbForge Studio for SQL Server. However, we added this suggestionon your behalf on our UserVoice forum to find out its importance for other users.

Please note that if you register on this forum, you can add your own suggestions or vote for existing ones.

Along that note how can server objects such as linked servers be viewed, altered and created within dbForge Studio?

We added this functionality in our roadmap for future product releases.

It has now been over 1 year since the original post.

Any progress/update on this functionality. I just downloaded Studio Pro for SQL Server (3.0.238) and need the same thing - access to linked server objects.

Thanks.

I did find another post that said to run the following to add the linked server.

exec sp_serveroption @server = 'server_name' , @optname = 'DATA ACCESS' , @optvalue = 'TRUE'

I did this and now the ServerName shows up in my intellisense, but that's as far as the intellisense goes. I have tried to "refresh suggestions", close, and reopen dbForge Studio but I still don't get any intellisense past the server name.

I can query objects in the linked server, just can't get intellisense. Any suggestions?

BTW - The linked server is using Oracle Provider for OLE DB, if that makes any difference.

Thanks.

It has now been over 1 year since the original post.

Any progress/update on this functionality. I just downloaded Studio Pro for SQL Server (3.0.238) and need the same thing - access to linked server objects.

Unfortunately, there is still no timeframe for implementing this.

I did find another post that said to run the following to add the linked server.

exec sp_serveroption @server = 'server_name' , @optname = 'DATA ACCESS' , @optvalue = 'TRUE'

I did this and now the ServerName shows up in my intellisense, but that's as far as the intellisense goes. I have tried to "refresh suggestions", close, and reopen dbForge Studio but I still don't get any intellisense past the server name.

I can query objects in the linked server, just can't get intellisense. Any suggestions?

BTW - The linked server is using Oracle Provider for OLE DB, if that makes any difference.

Oracle and MySQL linked servers are not supported in the Code Completion feature.