scheduled task not running

Transact-SQL

Index ‹ SQL Server

- Previous
  - 1
    - Convert Rows into Columns... (Cross tab). Jon: What version of SQL Server are you using Also, a cursor is NOT normally a good idea. Take a look at some of these posts: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1372104&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=892822&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=447559&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=437891&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=588762&SiteID=1 Please open a new thread and post what you are trying to accomplish. Tag: scheduled task not running
  - 2
    - DBCC CHECKDB & multipart identifier could not be bound Hi All, I have the following error message when running " DBCC CHECKDB WITH NO_INFOMSGS" : " The multi-part identifier "dbname.dbo.tablename.Amount" could not be bound." I do not understand why this error message is showing up. My 'Amount' column is defined as money. The server is a SQL2K5. Any help will be appreciated. Tag: scheduled task not running
  - 3
    - Log File path in Configuration file does not work. Gulden wrote: What is interesting is, I have Excel file connections in the same package with paths invalid for the target environment. Those work fine... Valid paths are read from the config. Thanks again.. Gulden Yeah but that's not really comparing apples with apples. A connection manager used by a logfile is used differently (i.e. alot more) than others. Also its a different type of connection manager. I haven't given a very good answer to this thread because frankly, I don't know what the proper answer is. At least it works now anyway. -Jamie Tag: scheduled task not running
  - 4
    - How to compare values in different rows? As long as you have that ID field, you can use the query Code Snippet CREATE TABLE prevRowTest ( ID INT , v1 INT , v2 INT ) INSERT INTO prevRowTest VALUES ( 1 , 2 , 8 ) INSERT INTO prevRowTest VALUES ( 2 , 7 , 10 ) INSERT INTO prevRowTest VALUES ( 3 , 11 , 15 ) INSERT INTO prevRowTest VALUES ( 4 , 13 , 17 ) SELECT prt . ID , prt . v1 , prt . v2 FROM prevRowTest prt JOIN prevRowTest prev ON prt . id = ( prev . ID + 1 ) WHERE prt . v1 <= prev . v2 Tag: scheduled task not running
  - 5
    - Why is taking so long to open/render the reports for the first time? I've wondered about this, and a genius friend of mine gave me this answer to a question that I think is of relevance. IIS churns alot the first time it loads after a reboot because it's loading the ap, this is my suspicion. -------------------------------- .Net is a binary application format. The bits and bytes of an .Net .exe or .dll are different from regular Windows .exe's and .dll's in that they are actually bytecodes, a low level programming language that all the .Net languages (C#, VB.NET, Managed C++, JScript.NET, etc. compile down to. The .Net loader converts the bytecodes on your harddisk to machine language (for the Pentium or whatever CPU you have) in memory before anything starts running. Normal .exe's and .dll's contain the machine language pre-generated in the file, and therefore have to be the lowest common denominator of all the CPUs you want your program to run on.. .Net also means using the .Net Framework. This is a bunch of .Net dlls that contain wrappers for the normal Windows and Web functions that exist in the Windows core, making them easier to call and much better organized. This is really hard to understand if you don't know C. Windows is a bunch of C-callable interfaces (collections of functions). Over the years, frameworks such as MFC, the VB runtime, etc. have tried to wrap the enormous number of functions available into better packages, callable from easier languages. .Net is the ultimate result of this, and is in fact so good that Windows itself is moving to adding new .Net functions first and C-callable functions later if at all. It's been 20 years since operating systems moved from machine language (the 8, 16, 32 or 64-bit wide sequence of bits that CPUs understand directly) to C. It happened with Unix first, and then DOS/Windows and other mini- and mainframe operating systems about the same time, one piece at a time. It's time to move from C to something higher level. Sun has made a mess of Java so the first operating system to move is going to be Windows, and the first language framework is .Net. Eventually all the 3rd party wrappers and frameworks get tired and you need the operating system itself to move up a level. .Net does run on Linux. The Mono project has been quite successful at moving the loader and a lot of the code libraries over. There's a lot of politics involved in getting people to use it in real projects though, and a .Net based Linux-like operating system is still a long ways away. Tag: scheduled task not running
  - 6
    - Table design question I have two identical tables: RCO and RI. Both have the following columns: SurveyID: Integer RespondentID: Integer ItemID: Integer Score: Integer value of the "score" for that ItemID where the SurveyID, RespondentID, and ItemID are all part of a Primary key. Per SurveyID I will typically have the following numbers: RespondentID: 1,000,000 of ItemID: 100 of That means there will be 1,000,000 x 100 = 100,000,000 Rows per Survey. I defined the rows as above as opposed to the following: SurveyID RespondentID Item1 Item2 Item3... Item100 where the "Score" is now kept in the individual Item column this results in per survey numbers of 1,000,000 Rows per table per survey or equal to the number of Respondents. A simple query against the two tables is a follows: SELECT PKID , ITEMID , SCORE , SUM ( SCORE ) AS ScoreSUM FROM RI WHERE ITEMID IN( 3 , 4 , 6 ) AND PKID IN ( SELECT PKID FROM RCO WHERE ( ITEMID = 3 AND SCORE = 382 ) OR ( ITEMID = 3 AND SCORE = 391 ) OR ( ITEMID = 3 AND SCORE = 55 )) GROUP BY PKID , ITEMID , SCORE ORDER BY PKID , ITEMID , SCORE We will need to cross the tables (using joins instead of above but the above was quick and easy to write) returning PKID, ITEMID, SCORE, SUM(SCORE) from RI based on Scores in the RCO table for particular ItemID's. Finally the question... Which table design will give use greater throughput on "Dynamic queries": ones that are created at run time Thanks, Kurt Tag: scheduled task not running
  - 7
    - Inconsistencies in FOR XML and Typed XML Schemas I'm writing an extract procedure that extracts data into nested XML. This XML is then passed to another SQL 2005 database that needs to consume it. However, this is not working and below is why. I'm hoping someone has a solution. One of the fields being extracted is datetime. As I've found and read, this causes problems. However, the bigger problem is with FOR XML. The statement extracts dates in the format: 2007-02-07T18:51:29.890 A typed XML schema requires there to be a time zone on the end in the format: 2007-02-07T18:51:29.890Z In order to validate that the XML is still valid from one database to the next, I need to create a typed schema, then load the incoming XML file into a column using that schema. As I'm sure you can tell by now, it fails. There are hundreds of articles on the fact that is must be valid and can't use sqltype:datetime but rather xsd:DateTime, but why doesn't FOR XML extract it in the right format to begin with My issue is in the inconsistency in the process. I should be able to extract data using FOR XML and import it into a typed XML schema column WITH NO CHANGES OR ISSUES with the extracted data! I should also be able to do this all with T-SQL and not use any other method (including XQuery and convert) to manipulate the XML first. Below is a script that can be used to validate my process. use tempdb go create xml schema collection dbo . testschema as N '<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"> <xs:element name="t"> <xs:complexType> <xs:sequence> <xs:element name="CurDate" type="xs:dateTime" /> </xs:sequence> </xs:complexType> </xs:element> </xs:schema>' GO create table temp ( MyXML xml ( DOCUMENT testschema )) GO -- use DEFAULT settings for generating xml: note that the date IS NOT extracted with 'Z' select CurDate from ( select getdate () curDate ) t for xml auto , type , elements /* Resulting XML document without schema looks as follows: <t><CurDate>2007-02-07T18:51:29.890</CurDate></t> */ GO DECLARE @order nvarchar ( MAX ) SELECT @order = '<t><CurDate>2007-02-07T18:51:29.890</CurDate></t>' insert temp values ( @order ) -- fails with this error: --XML Validation: Invalid simple type value: '2007-02-07T18:51:29.890'. Location: /*:t[1]/*:CurDate[1] GO -- add the 'Z', everything works DECLARE @order nvarchar ( MAX ) SELECT @order = '<t><CurDate>2007-02-07T18:51:29.890Z</CurDate></t>' insert temp values ( @order ) Tag: scheduled task not running
  - 8
    - Sql Query to Details about Database Is there any query to list all tables,column name,datatype,size,total record in each tables for particular database ex Database:Northwind Tables:categories,(categoryid varchar(50),Category name varchar(50)...............),1023kb ,25 records like this i think there is no such a simple query... Atleast tell How to get all column names and datatype of particular table and size of table Tag: scheduled task not running
  - 9
    - Create Report.rdlc in vb.net dynamically First I would create a procedure that looked something like Create Procedure Someprocedure @col1 varchar(50), @col2 varchar(50), @col3 varchar(50), @col4 varchar(50), @col5 varchar(50), @col6 varchar(50), @col7 varchar(50) as set nocount on select somestandardcolumns, col1=case when @col1='Fleet Manager' then table.fieldmanger when @col2=subfleetassignid' then table.subfleetassignid when @col3='homecenter' then table.homecenter etc,, else '' end col2= case when @col1='Fleet Manager' then table.fieldmanger when @col2=subfleetassignid' then table.subfleetassignid when @col3='homecenter' then table.homecenter etc,, else '' end etc.. Then I would design the report to support col1 through 7. The same @col procedure paramaters I would also use as report parameters and make those my columns headers. Then on the visibility property of the columns I would put =iif(len(Parameters!col1)=0,True,False). At least thats the basic idea. Tag: scheduled task not running
  - 10
    - SSEE Reporting Services - Can't get Report manager to work aha. (Don't worry about the Email settings and Exec, you're right about that, it's not critical.) 1. In ReportServerURL, put in <ReportServerUrl> http://<yourservername>/ReportServer </ReportServerUrl> ... do not put in <localhost> , use the server name 2. I am not positive but I think the ReportServerVirtualDirectory can, and possibly should, be empty: <ReportServerVirtualDirectory></ReportServerVirtualDirectory> ... try just change #1 first and see if that alone works but if not try both. >L< Tag: scheduled task not running
  - 11
    - Some questions about indices Hi all, we're planing to create a simple database with will work like a cache for a slow legacy system. The main work of this DB is to give results for search-queries. Each table will have up to 15 columns of different Datatypes and could contain up to 1.000.000 records. example columns of a Table: ID(int), guid (Uniqueidentifier), Subject(varchar(max)), Body(varchar(MAX)), IsComplet(bit), Startdate(DateTime), EndDate(DateTime) and so on... Typical searchqueries may be ("give me all items of a specific StartDate wich are complete" or "Give the item with the guid 'xxx-xxx...'. But also other combination are possible. Currently there are indices for the ID and guid columns. What is now the best practice to configure performant indices Have I to define an index for each column or for each possible combination of columns Many thanks Marcus Tag: scheduled task not running
  - 12
    - Restoring SQL database with failed backup I am needing to restore a SQL server 7 database. I had a backup, but the media it was on has failed. I have copies of the folder the original database was in (.mdf files and such), but I was wondering if there is a way to re-integrate these files in order to pick up where we left off. Thank you. Tag: scheduled task not running
  - 13
    - Filter multivalue DateTime parameter Use this for the filter expression: DateValue(CDate(Format(Fields!Field1.Value, "MM/dd/yyyy")) ) and leave the Parameter as it is and when you enter a value for it in Preview, type it in mm/dd/yyy format. Shyam Tag: scheduled task not running
  - 14
    - Login failed for user '(null)' Hi, I am using a Third Party software which depends on my SQL Server 2000 for storing data. When I use Windows Security in my Third Party software, I get the following message in the event viewer of my SQL Server 2000. Description: 18452: Login failed for user '(null)'. Reason: Not associated with trusted SQL Server connection. When I user SA, I do not get the above error. Any clarifications on the possibilites for getting the error is appreciated. Also let me know if we can overcome the error without using SA. I tried the article in http://support.microsoft.com/kb/840219 . But it didn't make a difference. Tag: scheduled task not running
  - 15
    - Is it possible to export a database model from visio to Sql Server 2005? Hi there, I cannot seem to find a way to export a database model from Visio to Sql Server. Can somebody provide a walkthrough how to export it Thanks a lot Tag: scheduled task not running
  - 16
    - Configuration Order Philip Coupar wrote: I have tried DTEXEC and using the SET options in SQL Agent, however it would also appear that these are applied after the internally specified configurations. At some point, are you using in your packages 'Parent Package variable' for setting any of the configurations If so, that may be the problem. There is a bug with configurations using 'parent package variables'. I am currently using XML file to set up the connection string of my SQL Server configuration table with no problem; I have done the same using Environment variables; if this is what you are doing the problem must be something else. Tag: scheduled task not running
- Next
  - 1
    - How do it right? I try to do conversation sending without any errors.And with clean sys.conversation_endpoints. There is my activation procedure code: Code Snippet SET NOCOUNT ON DECLARE @ConversationHandle UNIQUEIDENTIFIER DECLARE @ConversationGroupID UNIQUEIDENTIFIER DECLARE @MessageType NVARCHAR ( 126 ) DECLARE @Message VARBINARY ( MAX ) DECLARE @MessageXML XML ; WHILE ( 1 = 1 ) BEGIN SET @ConversationGroupID = NULL WAITFOR ( GET CONVERSATION GROUP @ConversationGroupID FROM [AGCapital/ServiceBroker/Queues/BrokerBug] ), TIMEOUT 1000 ; IF @ConversationGroupID IS NULL BEGIN BREAK END WHILE ( 1 = 1 ) BEGIN SET @MessageType = NULL SET @Message = NULL SET @ConversationHandle = NULL; RECEIVE TOP ( 1 ) @ConversationHandle = conversation_handle , @MessageType = message_type_name , @Message = message_body FROM [AGCapital/ServiceBroker/Queues/BrokerBug] WHERE conversation_group_id = @ConversationGroupID IF @@ROWCOUNT = 0 BEGIN BREAK END IF @MessageType = 'http://schemas.microsoft.com/SQL/ServiceBroker/EndDialog' OR @MessageType = 'AGCapital/ServiceBroker/Messages/Received' BEGIN END CONVERSATION @ConversationHandle ; BREAK END ELSE IF @MessageType = 'AGCapital/ServiceBroker/Messages/BrokerBug' BEGIN SET @MessageXML = CONVERT ( XML , @Message ); SEND ON CONVERSATION @ConversationHandle MESSAGE TYPE [AGCapital/ServiceBroker/Messages/Received] ; --do something BREAK END END END SET NOCOUNT OFF The code is identical on both services, Target and Iniciator. You can see, that it's work with it's own g aranteed delivering system - conversation endeds only when it's have confirmation of receiving mesage type AGCapital/ServiceBroker/Messages/BrokerBug' Looks like everything is rigth, but.. Profiler still show couple errors: on the Target server it is This message could not be delivered because the 'receive end conversation' action cannot be performed in the 'CLOSED' state. and on the iniciator An error occurred while receiving data: '64(error not found)'. Have you any ideas why it's happened Tag: scheduled task not running
  - 2
    - tabel scan Hi All, When an end user view a report using report manager or a custom build web site, would query of the report scan the tables in original data base In this case it is a OLTP data base. Thanks Tag: scheduled task not running
  - 3
    - Cannot Load SQLSpars.dll We'll likely need to see all the log files plus summary.txt, which is in their parent directory. The files are big enought that you shouldn't try to post them here. Instead, please provide a link. Paul Tag: scheduled task not running
  - 4
    - Strange thing in All examples at MSDN Hi, I have seen many examples at MSDN library related to SQL Querries in all queries one thing is same the way they use tables in there queries. BUT wht is this really i am not getting this, can anyone tell me.. the code and the problem is as follows: Code Snippet FROM Purchasing.ProductVendor JOIN Purchasing.Vendor ON (ProductVendor.VendorID = Vendor.VendorID) In the above code u see "Purchasing.ProductVendor", I want to ask that wht is this Purchasing Stands for, If we suppose that purxchasing is the database name then also normally we use database name as Purchasing.dbo.ProductVendor BUT I am not getting that what is this, Please if someone knows then explain it to me, Thanks. Tag: scheduled task not running
  - 5
    - SQL server database services option greyed out Hi, I'm trying to install SQL Server 2005 onto my XP Professional PC. When I get to the "Components to install" part, the "SQL server database services option" is greyed out. Infact, all options except "Workstation components..." are greyed out. I've tried uninstalling all previous versions of SQL server and trying again, but with the same results. any help would be much appreciated Simon Tag: scheduled task not running
  - 6
    - Where do I buy SQL Server Management Studio? Hi Jeffery, for the Express Edition the SQL Server Management Studio Express is the full version! What will you do What is the matter you won`t use it ... CU tosc Tag: scheduled task not running
  - 7
    - Sorting a table with numbers and letters I have a field (varchar) in a list that contains numbers and letters. I want to sort this table but I have only two functions that will work to convert the values: Val The Val function sorts the numbers in the string, but the letters are not sorted CStr The CStr function sorts the letters, but the numbers are not sorted How can I sort the numbers and letters Tag: scheduled task not running
  - 8
    - Error with SMO.TransferData() (Exception from HRESULT: 0xC0011008) Thank you for the example, Aaron. However, it did not work. Please note that I cannot connect to the default instance of SQL Server (also note that I only have SQL Express installed). I did try to apply your approach as best I could considering that I need to connect to the User Instance of SQL Express running with my application: Code Snippet Dim srv As Smo.Server Dim source As Smo.Server '*******This is the code to determine the Master Database name, used in original code Dim dbName_Master As String Dim SqlCon_Master As SqlClient.SqlConnection = New SqlClient.SqlConnection( My .Settings.LM_Master_SQLConStr) SqlCon_Master.Open() dbName_Master = SqlCon_Master.Database.ToString() 'This did not help: SqlCon_Master.ChangeDatabase("master") Console.WriteLine( "Master DB Name: " & dbName_Master) '******* Dim srvCon As New ServerConnection(SqlCon_Master) srv = New Smo.Server(srvCon) ''Verify User Instance connection Console.WriteLine( "User Instance Server: " & srv.InstanceName) If srv.Databases.Contains( "MasterDB_Copy" ) Then srv.Databases( "MasterDB_Copy" ).Drop() End If Dim newDB As New Smo.Database(srv, "MasterDB_Copy" ) newDB.Create() 'Create connection to Source DB Dim sourceCon As New ServerConnection(SqlCon_Master) source = New Smo.Server(sourceCon) ''Verify User Instance connection Console.WriteLine( "User Instance Server: " & source.InstanceName) Dim MasterDB As Smo.Database = source.Databases(dbName_Master) Dim xfr As New Smo.Transfer(MasterDB) xfr.CopyAllObjects = True xfr.DropDestinationObjectsFirst = True xfr.CopySchema = True xfr.CopyData = True xfr.DestinationServer = srv.Name xfr.DestinationDatabase = newDB.Name xfr.Options.IncludeIfNotExists = True Try xfr.TransferData() Catch ex As Exception Console.WriteLine( "Error: " & ex.Message) End Try srv = Nothing source = Nothing I still get the same error upon reaching TransferData(). If it means anything to this thread, I am using SMO for Backup and Restore successfully...so some SMO functions are working on my machine. Is there anything else I can try Thanks, AL Tag: scheduled task not running
  - 9
    - Can't uninstall SQL Server 2005 or install .NET 3.0 64bit after installing Office 2007 Well I had no response on the 64bit NET forum so I am posting here !! Windows Automatic Update has just failed to install .NET 3.0 (x64) WAU decided for itself that I needed this update Add Remove Programs reports the following (x64) programs ... .NET Framework 2.0 .NET Framework 2.0 SDK MS SQL SERVER 2005 VS2005 64bit prerequisites VS2005 64bit Remote Debugger MSinfo32 reports OS Name Microsoft(R) Windows(R) Server 2003 Standard x64 Edition Version 5.2.3790 Service Pack 2 Build 3790 Other OS Description R2 OS Manufacturer Microsoft Corporation System Name DEV-1 System Manufacturer Dell Inc. System Model Dell DXC051 System Type x64-based PC Processor EM64T Family 15 Model 6 Stepping 4 GenuineIntel ~3392 Mhz Processor EM64T Family 15 Model 6 Stepping 4 GenuineIntel ~3392 Mhz BIOS Version/Date Dell Inc. A05, 31/03/2006 BTW this is a fresh install because I was completely and utterly unable to uninstall SqlServer2005 which was necessitated by foolishly installing Office 2007 (Office 2003 being no longer available!) Tag: scheduled task not running
  - 10
    - Whats the different between SQL Express & SQL Server 2005? Hi, I'm working in a small company (less than 30 user), we can't buy MSSql Server 2005: Q1: can we use the Express edtion do access our data I mean for commersial purpose.. Q2: dose the Express edition stand to (30 connection) at the same time Q3: can I add users to it Tag: scheduled task not running
  - 11
    - SQL Server Management Studio Express on Vista Home Premium (Error on attaching and detaching .mdf) When you are launching the Management Studio are you right clicking it and choosing to run it as administrator This solved our issues trying to attach/detach databases in SQL 2005. Tag: scheduled task not running
  - 12
    - SUM returns incorrect value in SQL Server Mobile Query ... Bug?? Please mail to pragya dot agarwal at microsoft dot com Thanks Pragya Tag: scheduled task not running
  - 13
    - Blocking in Analysis Services We have a report in Reporting Services that connects to a Cube. The report has 4 input parameters that are also derived from the same cube. If the report is running and another user tries to select the drop downs for the report or runs just the query portion in report designer, the query will not return until the report has finished. It looks like the report is creating some type of wait. Has anyone ran across something like this Tag: scheduled task not running
  - 14
    - converting varchar to int Yes, it is definitely a varchar. You may have to look out for columns in the table that is being used as source to insert/update the value in the table which has a corresponding column of INT datatype. Shyam Tag: scheduled task not running
  - 15
    - Error - The report server cannot decrypt the symmetric key? Excluding snapshots, the actual data is not stored in the report catalog. Yes, you will loose only the data source credentials. You can go to the Report Manager to change them. FSE is about delivering subsribed reports (users can subscribe to reports believe it or not) to a network file share. Tag: scheduled task not running
  - 16
    - need to determine which db is pricipal Hi All, i am working with database mirroring and i need to be able to determine which database will be principal. for example if server A is principle and server B is mirrored and server A is down, then server B take owner and become principle, after fixing server A i want it to be principle again, is it possible Tag: scheduled task not running

b00gieman

Hi!

I've written an scheduled job for importing an excel file into a sql table.When I try to run the job from Sql server agent , I get the status 'Not running',and in the last run status,it's written 'failed'.I've tested the command before in the query analyzer,and it works.Can someone tell me why isn't this working as a scheduled job

Thanks in advance!

Re: scheduled task not running

dyarwood

Any chance of seeing the command Initial thoughts might be if the file is locked or opened somewhere else. Does the user that the SQL Server Agent run under has permissions to access the file Have you looked at the job history for any clues

Re: scheduled task not running

b00gieman

The command is:

INSERT INTO <sql table> SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=<excel file>;hdr=yes', 'SELECT * FROM [Sheet1$]')

Code Block

The file was closed...Could the result 'not running' be the result of a insufficient permission to run the scheduled job

Re: scheduled task not running

b00gieman

I've looked at 'job history'...It has a constant result of 'failed'.When I look into the step details,the following message is written:

Remote access not allowed for Windows NT user activated by SETUSER. [SQLSTATE 42000] (Error 7410). The step failed.

It seems that I don't have enough permissions... Sad

Re: scheduled task not running

dyarwood

I would suspect that user that the job (SQL Server Agent) is running under does not have access to that file. Find out what user the SQL Server Agent is running under and then check that user has permissions on the file and folder.