Can't run the scheduled SQL Agent Job?

SQL Server Security

Index ‹ SQL Server

- Previous
  - 1
    - The service pack level of SQL instance is not upto date No need to install SP1 you can directly upgrade to SP2. Tag: Can't run the scheduled SQL Agent Job?
  - 2
    - Flat file to DB upload approach question Hi guys, Suppose I have a flat file that had columns that went like this: rackId, cdname1, artist1, year1, cdname2, artist2, year2, cdname3, year3, artist3,...cdnameN, yearN, artistN And I want to map it to a table that has the ff columns: rack_id | CDName | Year | Artist Assuming that N is constant and all rows of the flat file will have N or less values filled up per rack, how do I map the fields from the flat file such that cdname1, cdname2 and cdname3 all fall under the CDName column, year1 and so on will fall under the Year column, and artist1 and so on will fall under the Artist column Tag: Can't run the scheduled SQL Agent Job?
  - 3
    - Time out Issues on big table Dear All, I am currently working in data migration project that involves bringing InterSystem Corporation's CACHE data tables into SQL Server 2000. Cache is a proprietary systerm with very limited capability . I have a table that has more than 400000 records in Cache and needed to bring this table in SQL server. I have time out issues with this. I wanted to separate the records into different batches and run one by one and put data into SQL server. But table data is random , i.e. non of the data entries can be used to segregate the table in blocks. For example, table structure looks like this Col1 Col2 Col3 Col4 Col5 2 e 567 th o 345 gg 445 yh u 56 r 3 y l Is there any way to deal with timeout issues and separte the table into many blocks Thanks Mike Tag: Can't run the scheduled SQL Agent Job?
  - 4
    - SDF Creation on Desktop Hi, i try to make a connection on a sql mobile database (*.sdf) from a desktop application made with VS2005 Beta 2 but i didn't manage. I dont' know where is my problem.... Is it possible or have I done something wrong thanks. Dotcom Tag: Can't run the scheduled SQL Agent Job?
  - 5
    - Drillthrough results conditioning Deepak - why to add expensive Order function Actually, to be compatible with DrillThrough, it is better to add Unorder instead :) Mosha. Tag: Can't run the scheduled SQL Agent Job?
  - 6
    - Restarted SQL Server 2005, and it's working great now, but WHY?? My small business has about 21GIGs of data in our database. This entire week we've been running absolutely slow. Posting transactions have been taking up to 30+ seconds when they're normally instant. We ran the profiler and found that certain stored procedures were taking an absolutely long time to run. We checked for fragmentation, indexing, etc. Keep in mind our hardware was constantly pegged at 80%+ all the time. We have about 60 users connected to our server at any given time. After much effort to no avail, we finally resorted to just restarting the software. Some have even suggested powering down and rebooting our hardware, but I halted that. We stopped and restarted the server via the management studio and now everything is just peachy. We're funning super fast and smooth. My concern is that we're just bandaid-ing the problem and not resolving it; so eventually we're going to be faced with this problem again. Even though restarting the server is quite easy and not too effective on our downtime, personally, I'd like to know what the real issue is. Isn't sql server 2005 a self-tuning software to begin with Has anyone experienced this and share some insights on what they did and didn't do to resolve this quirk Tag: Can't run the scheduled SQL Agent Job?
  - 7
    - Unpivot Transformation and Expressions Thank you! Tag: Can't run the scheduled SQL Agent Job?
  - 8
    - Oracle odbc driver on windows 2003 64 bit, SQL Server 2005 Oh! Was it that simpel! Thanks for your answer. I could set up my odbc links, but I could't find Oracle oledb provider under linked servers. Do you have a tip on that Tag: Can't run the scheduled SQL Agent Job?
  - 9
    - Partitioned View Pruning Issue The bogus data helped some. Now it's behaving the same way it would if I manually created additional indexes on the PK. However, it's still not properly pruning the data out of the view. Here's the query I'm running and the output I'm getting. DECLARE @p bit SET @p = NULL DECLARE @callId varchar(64) SET @callId = '2004010100281315' DELETE FROM Call WHERE [id] = @callId AND @p IS NULL STATISTICS IO (I deleted quite a bit): Table 'Call_2006_12'. Scan count 0, logical reads 0, physical reads 0, read-ahead reads 0. ... [All other tables between are the same as the above] ... Table 'Call_2004_02'. Scan count 0, logical reads 0, physical reads 0, read-ahead reads 0. Table 'Call_2004_01'. Scan count 1, logical reads 3, physical reads 0, read-ahead reads 0. (0 row(s) affected) Table 'sysmergearticles'. Scan count 1, logical reads 4, physical reads 0, read-ahead reads 0. Table 'MSmerge_replinfo'. Scan count 22, logical reads 44, physical reads 0, read-ahead reads 0. Table 'sysmergesubscriptions'. Scan count 1, logical reads 2, physical reads 0, read-ahead reads 0. Table 'MSmerge_tombstone'. Scan count 0, logical reads 0, physical reads 0, read-ahead reads 0. Table 'MSmerge_contents'. Scan count 0, logical reads 0, physical reads 0, read-ahead reads 0. Table 'sysmergearticles'. Scan count 1, logical reads 4, physical reads 0, read-ahead reads 0. (15 row(s) affected) [the above (starting with the first "Table 'sysmergearticles'") repeats 35 more times] SHOWPLAN_TEXT Results (again, edited for size): |--Sequence |--Clustered Index Delete(OBJECT:([Callbright].[dbo].[Call_2004_01].[PK_Call_2004_01])) | |--Filter(WHERE:(STARTUP EXPR([@p]=NULL))) | |--Filter(WHERE:(STARTUP EXPR([@callId]<'200402' AND [@callId]>='200401'))) | |--Clustered Index Seek(OBJECT:([Callbright].[dbo].[Call_2004_01].[PK_Call_2004_01]), SEEK:([Call_2004_01].[id]=[@callId]) ORDERED FORWARD) ... [All other tables between are the same as the above] ... |--Clustered Index Delete(OBJECT:([Callbright].[dbo].[Call_2006_12].[PK_Call_2006_12])) |--Filter(WHERE:(STARTUP EXPR([@p]=NULL))) |--Filter(WHERE:(STARTUP EXPR([@callId]<'200701' AND [@callId]>='200612'))) |--Clustered Index Seek(OBJECT:([Callbright].[dbo].[Call_2006_12].[PK_Call_2006_12]), SEEK:([Call_2006_12].[id]=[@callId]) ORDERED FORWARD) Also, I should mention that the Clustered Index Delete takes 2% of the execution time and performs 1 execution while the Clustered Index Seek takes 1% of the execution time and performs 0 executions on the tables that should be pruned. Any ideas Tag: Can't run the scheduled SQL Agent Job?
  - 10
    - Backup on remote disk hi gurus, can any bdy tell me the procedure to create the Backup Device which is a DISK OF REMOTE PC.. i want to take database backup on remote pc's disk not on local disk or tape i am using sql server 2005 thanks in advance Tag: Can't run the scheduled SQL Agent Job?
  - 11
    - Insert failure while using ForEach Loop + Execute SQL task. OK, maybe it does not like the * in your select statement. Why don't you try explicitly specifying the first column. When you specify * the statement is obviously going to return multiple columns, and if all you are interested is in the first column just state it explicitly. Tag: Can't run the scheduled SQL Agent Job?
  - 12
    - statment completion in vidual studio 2005 i'm using vs 2005 pro edition i try to enable the statment completion in option menu i try this path (otpton ->text editon->sql script ) but statment completion is grayed i can not check this part how i must do to enable it thank a lot Tag: Can't run the scheduled SQL Agent Job?
  - 13
    - How to count no of items in nested table Thank you for your solution however could you explain more details about the logic behind the function do, i am a little bit lost,also how can i translate it into stored procedure that I will use to retrieve the no_of_restaurants based on the regionID. Tag: Can't run the scheduled SQL Agent Job?
  - 14
    - sp_sidmap alternative in sql 2005 I use sp_sidmap in SQL Server 2000. I changed from sp_change_users_login because sp_sidmap handles both standard and windows logins. In SQL Server 2005, sp_sidmap is gone and I see threads saying you can't add it. Do you know of an alternative to sp_sidmap in SQL Server 2005 so that I can automate the relinking of users to both standard and windows logins when copying databases across servers Thanks, Dan Tag: Can't run the scheduled SQL Agent Job?
  - 15
    - copying and pasting cubes Hello, I was copying and pasting cubes (sql 2000) today--- Like I have done several times before.. And I got this error: Unable to set new aggregation prefix for at least one partition. Please change these manually to avoid conflicting aggregation tables. What does it mean How can i fix it Thank you, Liat Tag: Can't run the scheduled SQL Agent Job?
  - 16
    - Group Total Summary Help Thanks again for your detailed answer. You have the right idea with the data, but because the detail data needs the summary for the total group I am not able to carry the expression down. I get an error (can't sum expression with aggregates.). Using your example, we would need to know the summary of total fruit for the day to determine the percentage of daily fruit represented by pears (or apples or oranges). I would then need to summarize all percentages for an overall total. For now I overcame my issue by bringing back group totals in my query. I was just hoping I wouldn't need to do this. In crystal I was able to create a global variable that could be set with each group and displayed at the end. I can't find a way to do this in RS. Tag: Can't run the scheduled SQL Agent Job?
- Next
  - 1
    - urgent server installing problems the error shown as soon as i try to install sql serevr 2000 is that "Microsoft sql server 2000 standard edition server component is not supported on this operating system . only client components will be available for isntallation.... and no i dont ahve any other sql installed on this Pc of mine..... hope u help me fix and runn this sqlserver 2000.... :) thanku Tag: Can't run the scheduled SQL Agent Job?
  - 2
    - Commit Error I have an SSIS package that iterates through a thousand or so download text files, parses them and inserts the results into a database via a Stored procedure and an OLE DB Command. For the most part this process works without any issues, yet I keep obtaining random errors on a DT_STR (500) column. I have reviewed the data extensively and this column - which is the same across all of the rows - does not appear to be any different. The rest of the rows before and after the error rows all insert properly but these rows consistently fail in the OLE DB task with the following error: [OLE DB Command [35549]] Error: An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. The RPC name is invalid.". When I inserted the rows into an errors table, I found that the error code, -1071607698, is not defined and the only thing I could find online was a reference to: DTS_E_COMMANDDESTINATIONADAPTERSTATIC_UNAVAILABLE which appears to be a DTS error and not an SSIS error. I have added tasks to explicitly verify the length of the field and that field actually inserts without any issues into the error table - which has the exact same column definition as the target table. I am at a complete loss as to how to proceed - does anybody have an idea Tag: Can't run the scheduled SQL Agent Job?
  - 3
    - Snapshots - not having to create them Hi I am creating a full Merge replication setup between two servers Is there any way that I can set it up so that I do not have to create a snapshot. Ie I would gurantee that the data and structutre is EXACTLY the same on both the subscriber and the publisher. The problem is that my data base is over 4GB and it is quicker for me to get the data from one server to the other by doing a backup and restore. I am using SQL 2005 with the latest SP Cheers Ants Tag: Can't run the scheduled SQL Agent Job?
  - 4
    - error using default value property in table column properties (mssqlserver sme)(mssql2005 express) I'm trying to set the NOW() function as default value property of a table field (datetime type) but I'm getting the folowing errors: error validating the default for column 'optime' 'NOW' is not a recognized built-in function name i used now, now(),NOW,NOW() as default value property sorry 'my bad english' Tag: Can't run the scheduled SQL Agent Job?
  - 5
    - Passing value from a child Package to the Parent package that calls it in ssis smathew wrote: i believe it show how to pass from the parent to the child.. I am aware of that.. I was looking from child to parent... Thanks If you execute the child package from script, the parent package can read the child's variable values after execution, thus passing the value back to the parent. http://blogs.msdn.com/jamesk/archive/2005/12/21/506463.aspx Tag: Can't run the scheduled SQL Agent Job?
  - 6
    - Using SQL Server Destination adapter with SQL 2000 database It��s always said that using the SQL Server Destination adapter is much faster when loading data to a SQL Server database. My question is, if I have a SQL 2000 database, can I still use the SQL Server Destination adapter, or is it only for SQL 2005 db Is OLE DB Destination adapter my best bet My data files(flat files), SSIS package and destination SQL 2000 db are all in the same physical server. Tag: Can't run the scheduled SQL Agent Job?
  - 7
    - using trigger to insert data to different server database i have 2 server named A and B in A server have database server and B have database server in A have database named A1 with table TA1 and in B have database named B1 with table TB1 i want if i insert data into database A1 table TA1 in server A, database B1 table TB1 in server B will insert the same data to how can do that with trigger or other ways thx u Tag: Can't run the scheduled SQL Agent Job?
  - 8
    - Error 26 on a local machine I am getting the "Error Locating Server/Instance Specified" message. The part I find most confusing is that I am connecting to my database locally. I have read the recommendations on the blog posted here: http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx and implemented them to no avail. The confusing part is that I only have this problem on one particular application, which I am not the original author of. When I build my connection to the very same server (different database) using the Data Source configuration wizard, it works just fine. Any help would be greatly appreciated. Tag: Can't run the scheduled SQL Agent Job?
  - 9
    - Period over Period The hierarchy is the natural calendar hierarchy: year - qtr - month - week - day However, I can change my time dimension to make the implementation of Period over Period more easy, so if there is a problem with this, then I could make changes there. dcb99 Tag: Can't run the scheduled SQL Agent Job?
  - 10
    - Virtual Address Space very large When I run dbcc memorystatus on my SQL 2005 Server under Memory Manager I get: VM Reserved 33610144 VM Committed 1478012 Doesn't the VM Reserved seem really high Is there a way to force SQL to release the VM Reserved memory Tag: Can't run the scheduled SQL Agent Job?
  - 11
    - Parent Package Variables and SQL Package Store EWisdahl wrote: Well, I just spent a few hours converting those packages over to store the data source, initial catalog, name and password as seperatre variables and build the string up in the expression for the connection string. When I ran the package it was still pointing to the "default" values defined in the child package, even though I had changed the parent to point to a different data base within the source... Any ideas Are you certain that the parent package variable configuration is set up properly You may want to try adding a Script Task to your control flow, and within it using a MessageBox to pop up the value being configured just to validate. Personally, I solve this problem with XML file configurations. I have one dtsConfig file that drives the ConnectionString property of the connection, and have connection managers with the same name in my master and child packages, and this works great for me. Tag: Can't run the scheduled SQL Agent Job?
  - 12
    - Select Stament Help Hi: I need help to make a query to relate diameters reading at a specified time to specific alarms at a different time but whiting 15 second of difference. I.e. for every alarm event I want to now the diameter values during 15 seconds before and after time frame. Any help will be appreciated. Table Diam tsTimeStamp rDiameter 1/10/2007 8:05:45 AM 3.2 1/10/2007 8:05:50 AM 2.9 1/10/2007 8:05:55 AM 3.3 1/10/2007 9:15:45 AM 3.3 1/10/2007 9:15:50 AM 2.7 1/10/2007 9:15:55 AM 2.8 Table Alarm tsAlarmTime Alarm 1/10/2007 8:05:51 AM 1001 1/10/2007 9:15:51 AM 1001 Query Result tsAlarmTime tsTimeStamp Alarm rDiameter 1/10/2007 8:05:50 AM 1/10/2007 8:05:45 AM 1001 3.2 1/10/2007 8:05:50 AM 1/10/2007 8:05:50 AM 1001 2.9 1/10/2007 8:05:50 AM 1/10/2007 8:05:55 AM 1001 3.3 1/10/2007 9:15:50 AM 1/10/2007 9:15:45 AM 1001 3.3 1/10/2007 9:15:50 AM 1/10/2007 9:15:50 AM 1001 2.7 1/10/2007 9:15:50 AM 1/10/2007 9:15:55 AM 1001 2.8 Tag: Can't run the scheduled SQL Agent Job?
  - 13
    - Update data on SQL2005 linked servers to DB2 Hi all. I need your help. I create a linked server on SQL 2005 server using IBMDA400 as provider. I create a VBscript to update some data on DB2, and issue begin trans and commit trans. Kindly refer to below code. ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Set oKCDat = CreateObject("KCDAT.kcdatapi") Set objConnection = oKCDat.OpenConnection_SQL(strDataSource,strDB, strUserID, strPassword) Set rs = CreateObject("ADODB.Recordset") strName = "TEST1" strTemp1 = "2" strTemp2 = "3" intTemp1 = 199 strSQLStatement = "SELECT * FROM QS36F.TEST WHERE PRACNM = ''" & strName & "''" strUpdSQL = "TEST1 = '" & strTemp1 & "', TEST2 = '" & strTemp2 & "', TEST3 = " & intTemp1 strSQL = "UPDATE OPENQUERY(TESTDB2," & "'" & strSQLStatement & "')" & " SET " & strUpdSQL & ";" objConnection.BeginTrans objConnection.Execute(strSQL) objConnection.CommitTrans objConnection.Close Set rs = Nothing Set oKCDat = Nothing Set objConnection = Nothing ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- When i run above script, it prompt me an error message; " Microsoft OLE DB Provider for SQL Server The requested operation could not be performed because OLE DB provider "IBMDA400" for linked server "TESTDB2" does not support the required transaction interface ." If i run it without "begintrans" and "committrans", it update the data successfully. Does anyone know about it Highly appreciated for above matters. Regards Tag: Can't run the scheduled SQL Agent Job?
  - 14
    - SQL Server 2005 Cluster Hi all , i need any white paper or case study how to configure win server 2003 cluster and install sql server 2005 cluster . thanks in advance Tag: Can't run the scheduled SQL Agent Job?
  - 15
    - Time dimension design Thanks, its clearer now. So the date_SK and Country_SK in the Fact_sales will be linked to dim_connection. How will the dim_connection be linked the n dim_date tables and in the AS how do you translate this in the Dimension Usage section One more question, what advantage does this approach have on putting all the date dimensions in one dimension with a key referring to the country in it example: Dim Date ---------------- date_SK (primary key) country_code date month year week ....etc Thanks again. Christina Tag: Can't run the scheduled SQL Agent Job?
  - 16
    - Error: Method, property or field is not static In order to use debugging functionality, you need to provide SQL Server with the PDB file for your project. In order to do this, you will need to execute something like this: ALTER ASSEMBLY cprTWR ADD FILE 'C:\...\Visual Studio 2005\Projects\cprTWR\cprTWR\bin\Release\cprTWR.pdb' Although mentioned in the doc, I find this blog post interesting when it comes to debugging. Tag: Can't run the scheduled SQL Agent Job?

Mapperkids

Hi,

I'm tried to run the job that created from maintenance plan. It fail and give me the following message:

[298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'DOMAIN\MYNAME', error code 0x5. [SQLSTATE 42000] (ConnIsLoginSysAdmin)

We are using the Windows Autheniciaton mode only and my id is set as sysadmin, setadmin, processadmin in the server roles.

I don't why I can't run the job, I check the SQL agent services is login using LOCALSYSTEM.

I try to the NT admin account to login the box, but still getting the same error message.

Any idea

Thanks!

Re: Can't run the scheduled SQL Agent Job?

Satya SKJ

use a local login for the SQLAgent and try to schedule it again.

Re: Can't run the scheduled SQL Agent Job?

Mapperkids

Hi,

What is local login we only setup use the windows authenication mode for the sql server

Thanks!

Re: Can't run the scheduled SQL Agent Job?

Madhu K Nair

this may help u : http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=102884&SiteID=1

change the owner of the job

Madhu

Re: Can't run the scheduled SQL Agent Job?

Laurentiu Cristofor

Is the SQL Server machine in the same domain as the user mentioned in the error message

The 0x5 error code means access denied - the DC doesn't allow you to query the user information. If there are different domains involved, you may need to set the trust between them.

Also, what did you say you tried at the end of your message There is a word missing I think.

Thanks
Laurentiu