ttinsley
asked on
SQL Server Agent - 2005, cannot view jobs even though I created them
I am running a local copy of SQL server 2005 and using SSMS to manage information on a SQL Server 2000 installation. Recently I created some jobs that are running fine against the 2000 Server and db. The problem is that I can't View, Delete or Edit these jobs. I know they are running because I can see them clearly in "View History" when I right click on the "Jobs" Folder. When I try to refresh the folder I receive the following:
========================== =========
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEn um)
-------------------------- ----
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
-------------------------- ----
Program Location:
at Microsoft.SqlServer.Manage ment.Smo.E numerator. Process(Ob ject connectionInfo, Request request)
at Microsoft.SqlServer.Manage ment.UI.VS Integratio n.ObjectEx plorer.Nav igableItem Builder.Bu ildDynamic ItemWithQu ery(IList nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery, Boolean registerBuilder, Boolean registerBuiltItems)
at Microsoft.SqlServer.Manage ment.UI.VS Integratio n.ObjectEx plorer.Nav igableItem Builder.Bu ildDynamic Item(IList nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)
at Microsoft.SqlServer.Manage ment.UI.VS Integratio n.ObjectEx plorer.Nav igableItem Builder.Bu ild(INodeI nformation source, INavigableItem sourceItem, IFilterProvider filter)
at Microsoft.SqlServer.Manage ment.UI.VS Integratio n.ObjectEx plorer.Nav igableItem .GetChildr en()
at Microsoft.SqlServer.Manage ment.UI.VS Integratio n.ObjectEx plorer.Sum maryView.g et_Items()
at Microsoft.SqlServer.Manage ment.UI.VS Integratio n.AppIDPac kage.ListV iewVirtual Storage.Co pyItems(IS ummaryView summaryView)
at Microsoft.SqlServer.Manage ment.UI.VS Integratio n.AppIDPac kage.ListV iewVirtual Storage..c tor(ISumma ryView summaryView, List`1 columnDescriptors)
at Microsoft.SqlServer.Manage ment.UI.VS Integratio n.AppIDPac kage.Right PaneListVi ewer.Popul ateView()
========================== =========
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Conne ctionInfo)
-------------------------- ----
Program Location:
at Microsoft.SqlServer.Manage ment.Commo n.ServerCo nnection.E xecuteWith Results(St ring sqlCommand)
at Microsoft.SqlServer.Manage ment.Smo.E xecuteSql. ExecuteWit hResults(S tring query)
at Microsoft.SqlServer.Manage ment.Smo.E xecuteSql. ExecuteWit hResults(S tringColle ction query, Object con)
at Microsoft.SqlServer.Manage ment.Smo.P ostProcess JobActivit y.GetColum nData(Stri ng name, Object data, DataProvider dp)
at Microsoft.SqlServer.Manage ment.Smo.D ataProvide r.Manipula teRowDataP ostProcess ()
at Microsoft.SqlServer.Manage ment.Smo.D ataProvide r.GetTable ()
at Microsoft.SqlServer.Manage ment.Smo.S qlObjectBa se.FillDat a(ResultTy pe resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
at Microsoft.SqlServer.Manage ment.Smo.S qlObjectBa se.FillDat aWithUseFa ilure(SqlE numResult sqlresult, ResultType resultType)
at Microsoft.SqlServer.Manage ment.Smo.S qlObjectBa se.BuildRe sult(EnumR esult result)
at Microsoft.SqlServer.Manage ment.Smo.S qlObjectBa se.GetData (EnumResul t erParent)
at Microsoft.SqlServer.Manage ment.Smo.E nvironment .GetData()
at Microsoft.SqlServer.Manage ment.Smo.E nvironment .GetData(R equest req, Object ci)
at Microsoft.SqlServer.Manage ment.Smo.E numerator. GetData(Ob ject connectionInfo, Request request)
at Microsoft.SqlServer.Manage ment.Smo.E numerator. Process(Ob ject connectionInfo, Request request)
========================== =========
A severe error occurred on the current command. The results, if any, should be discarded. (.Net SqlClient Data Provider)
-------------------------- ----
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0760&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476
-------------------------- ----
Server Name: ARES
Error Number: 0
Severity: 11
State: 0
-------------------------- ----
Program Location:
at System.Data.SqlClient.SqlC onnection. OnError(Sq lException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlI nternalCon nection.On Error(SqlE xception exception, Boolean breakConnection)
at System.Data.SqlClient.TdsP arser.Thro wException AndWarning (TdsParser StateObjec t stateObj)
at System.Data.SqlClient.TdsP arser.Run( RunBehavio r runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlD ataReader. SetMetaDat a(_SqlMeta DataSet metaData, Boolean moreInfo)
at System.Data.SqlClient.TdsP arser.Run( RunBehavio r runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlD ataReader. ConsumeMet aData()
at System.Data.SqlClient.SqlD ataReader. get_MetaDa ta()
at System.Data.SqlClient.SqlC ommand.Fin ishExecute Reader(Sql DataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlC ommand.Run ExecuteRea derTds(Com mandBehavi or cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlC ommand.Run ExecuteRea der(Comman dBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlC ommand.Run ExecuteRea der(Comman dBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlC ommand.Exe cuteReader (CommandBe havior behavior, String method)
at System.Data.SqlClient.SqlC ommand.Exe cuteDbData Reader(Com mandBehavi or behavior)
at System.Data.Common.DbComma nd.System. Data.IDbCo mmand.Exec uteReader( CommandBeh avior behavior)
at System.Data.Common.DbDataA dapter.Fil lInternal( DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataA dapter.Fil l(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataA dapter.Fil l(DataSet dataSet)
at Microsoft.SqlServer.Manage ment.Commo n.ServerCo nnection.E xecuteWith Results(St ring sqlCommand)
I am pretty certain I have a permission issue because I can view, edit and delete jobs running against my local installation SQL Server 2005
==========================
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEn
--------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
--------------------------
Program Location:
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
==========================
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Conne
--------------------------
Program Location:
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
==========================
A severe error occurred on the current command. The results, if any, should be discarded. (.Net SqlClient Data Provider)
--------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0760&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476
--------------------------
Server Name: ARES
Error Number: 0
Severity: 11
State: 0
--------------------------
Program Location:
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.TdsP
at System.Data.SqlClient.TdsP
at System.Data.SqlClient.SqlD
at System.Data.SqlClient.TdsP
at System.Data.SqlClient.SqlD
at System.Data.SqlClient.SqlD
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlC
at System.Data.Common.DbComma
at System.Data.Common.DbDataA
at System.Data.Common.DbDataA
at System.Data.Common.DbDataA
at Microsoft.SqlServer.Manage
I am pretty certain I have a permission issue because I can view, edit and delete jobs running against my local installation SQL Server 2005
You have posted this to the Oracle PL/SQL topic. Try posting to MS SQL Server topic more more/better responses.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.