Reporting errors & output from SQL Agent

SQL Server Database Engine

Index ‹ SQL Server

- Previous
  - 1
    - Altering Table Replicated In SQL Server 2005 you can use alter table syntax to add/remove/change columns in a replicated table. Check out the following link for more information -- http://msdn2.microsoft.com/en-us/library/ms151870.aspx If you are using SQL 2000, you are limited to the functionality of sp_repladdcolumn and sp_repldropcolumn. SQL Server 2000 Books Online will give you more information on the syntax of these procs. Hope this helps, Tom This posting is provided "AS IS" with no warranties, and confers no rights. Tag: Reporting errors & output from SQL Agent
  - 2
    - SQL 2000 Monitoring Tools If you are looking for direction on built in commands, you can start with executing sp_who2, sp_lock and you can select from master..sysprocesses. That would first steps for troubleshooting when someone says something the server is slow. If you need to monitor over time to determine resources, you use a trace to caputre the information, import the trace files into some other SQL Server instance where you can write queries to determine usage numbers. -Sue Tag: Reporting errors & output from SQL Agent
  - 3
    - Non significant '0' removed from alphanumeric code Double check all of your metadata links and double check on the advanced editor screens that you don't inadvertently have that column cast as a numeric data type. Tag: Reporting errors & output from SQL Agent
  - 4
    - best practice for ragged delimited text import If you are guaranteed to have at least one more column than the required ones, you can configure the columns you care about with the tab delimiter, and then a final column with the CR/LF delimiter that will get the rest of the row. If not (and it looks like you can't, from your example), then you'll have to configure the last required column with the CR/LF delimiter. That way the last column will hold the last value that you want, and the rest of the row, if it exists. Then use a Derived Column transform with the FINDSTRING and SUBSTRING functions to get everything up to the tab. Sorry, but I don't think there is an easier solution. Tag: Reporting errors & output from SQL Agent
  - 5
    - SP2 shipped! Anybody know if this SP2 solves the problem with Foxpro OLE datasources that SP1 created I dunno if anyone else remembers but when SP1 came out and people installed it they suddenly found that they could no longer use SSIS with the FoxPro OLE connections... So we all had to go and reinstall SQL Server 2005 to get our packages running again... Thanks Tag: Reporting errors & output from SQL Agent
  - 6
    - Using MDX Scope Statement in RS2005 It won't. Scope assignments can be defined only in the cube MDX script. I am curious why you want to do this in your report though. Tag: Reporting errors & output from SQL Agent
  - 7
    - AS400 DB2 connection strings I don't understand what you're looking for. Can you be more specific If trigger code isn't called, how is that an SSIS issue Tag: Reporting errors & output from SQL Agent
  - 8
    - Bootstrapping SQL Server Express RichLeyshon wrote: Can someone tell me if there is a definitive description somewhwere re how to get SQL Server 2005 to install from the same CD as a VB application. You can do it by right clicking your setup application>properties>prerequisites>Mark "SQL Server Express Edition">And check "Download prerequisites from the same location as my application" And Mike's article may help: http://blogs.msdn.com/sqlexpress/archive/2006/09/20/763956.aspx Tag: Reporting errors & output from SQL Agent
  - 9
    - Report Builder Permissions I believe users need to have at least Browser permission on all the parent folders of a given folder in addition to the folder itself. So yes, they will need to have permission to the Home folder. However, this will not (by itself) allow them to see subfolders of the Home folder to which they do not have permission. So you should still be able to hide the folders you don't want them to see. Hope this helps! Tag: Reporting errors & output from SQL Agent
  - 10
    - cube browsing permissions - what am I doing wrong? Did you enable "Read Definition" permission on the General tab of the Role designer - that might help Tag: Reporting errors & output from SQL Agent
  - 11
    - Learning T SQL This is the best place and resource for a PL/SQL developer because books are known to be error prone, this tells you in detailed form how and what is implemented in the current SQL Server. Pay close attention to what Microsoft did not say and how it is said. Post again if you still need help, I use both Oracle and SQL Server. http://msdn2.microsoft.com/en-us/library/ms189826.aspx Tag: Reporting errors & output from SQL Agent
  - 12
    - Opening table causes exception thrown by the target of an invocation What version of SQL Server are you using You might want to have a look at the KB Article: List of bugs that are fixed in Microsoft .NET Framework 1.0 Service Pack 3 http://support.microsoft.com/default.aspx scid=kb;EN-US;867461 Search for "Exception has been thrown by the target of an invocation" in the KB Article. Tag: Reporting errors & output from SQL Agent
  - 13
    - MDX Query Issue "I thought about accessing the TypeCode and Price attributes through the member properties collection, but this would mean that I would need to use the ProductKey which make the performance of the query even worse." - what are the attribute relationships in the Product dimension For a given SKU, it sounds like there can be different TypeCode and Price attribute values (SCD Type 2) - should all values be returned, or only those related to certain dates Tag: Reporting errors & output from SQL Agent
  - 14
    - Creating a Trigger that emails when new record is added. Hello, Try this: create trigger tr_ESSPartNumLog_Insert on dbo . ESSPartNumLog for insert as declare @id as integer declare @q as varchar ( 255 ) --Get ID of record inserted. select @id = ESSSequence from inserted --Create query string to return the record select @q = 'select ESSSequence, MaterialType, ESSPrefix, PartDescription, Project, PM from ESSPartNumLog where ESSSequence = ' + convert ( varchar ( 10 ), @id ) exec msdb . dbo . sp_send_dbmail @recipients = 'your_email@domain.com' , @subject = 'New record added in ESSPartNumLog' , @query = @q , @execute_query_database = 'Engineering' go Hope this helps. Jarret Tag: Reporting errors & output from SQL Agent
  - 15
    - Find the last record by date in a sub group of records. If you are using SQL Sever 2005 you ought to be able to use the ROW_NUMBER() function to improve on this. Another possibility is to take the max of a "tag along" vector to retain the information. Which version of SQL Server are you using The SQL Server 2005 code might look something like: Code Block declare @xample table ( PollId integer, CoveragId integer, EffDate datetime, Status char(1), Limit1 integer ) insert into @xample select 2, 1, '9/7/2007', 'a', 10000 union all select 2, 2, '9/7/2007', 'a', 15000 union all select 2, 2, '10/1/2007','a', 20000 union all select 3, 1, '9/7/2007', 'a', 10000 --select * from @xample select pollId, CoveragId, EffDate, Status, Limit1 from ( select PollId, row_number() over ( partition by PollId order by CoveragId desc, EffDate desc, Limit1 ) as Seq, CoveragId, EffDate, Status, Limit1 from @xample ) a where seq = 1 /* pollId CoveragId EffDate Status Limit1 ----------- ----------- ----------------------- ------ ----------- 2 2 2007-10-01 00:00:00.000 a 20000 3 1 2007-09-07 00:00:00.000 a 10000 */ Tag: Reporting errors & output from SQL Agent
  - 16
    - Non-additive measures What is the granularity of rates in the fact table If they are entered, for example, per Account and Time - you should create new measure group at that granularity. Tag: Reporting errors & output from SQL Agent
- Next
  - 1
    - MSSQLServer logging many missing stored procedure messages Brian, Did you find a solution for this issue I am having the same issue and wish to find a solution. Thanks. Giri Tag: Reporting errors & output from SQL Agent
  - 2
    - VERY slow stored procedure performance on datetime parameter Hi, If you use two date parameters which forms a date range, and if the first call of the SP is run with a small date range then the SP is compiled to use an execution plan which is suitable for those parameters. And after the compilation, if you give parameters that form a huge date range, that may be slow to get the results with the compiled execution plan. You may create the SP with recompile hint for such situations. But this causes the SP to be recompiled everytime it is called. Do you think this may be a reason CREATE PROC spname { parameter list } WITH RECOMPILE AS ..... Eralper http://www.kodyaz.com Tag: Reporting errors & output from SQL Agent
  - 3
    - search for last non-null field in a row? This work's in SS2005 Code Snippet create table #old ( id int , date datetime , c1 int , c2 int , c3 int , c4 int ) insert into #old values ( 1 , getdate ()- 10 , null, 10 , 20 , null) insert into #old values ( 2 , getdate ()- 9 , 1 , 2 , 3 , null) declare @id int , @dt datetime , @maxcol varchar ( 3 ) set @id = 1 set @dt = ( select date from #old where id = @id ) set @maxcol = 'c4' ; with legacydata as ( select * from ( select * from #old ) as pvt UNPIVOT ( Data FOR Col IN ( c1 , c2 , c3 , c4 ) ) AS unpvt ) select top 1 * from legacydata where id = @id and date = @dt and col < @maxcol order by col desc Tag: Reporting errors & output from SQL Agent
  - 4
    - Help with query Nothing wrong with your query, the tables are properly joined -IF both have a column [OpportunityID]. However, are you sure that there is data in both tables with the exact same [OpportunityID] Tag: Reporting errors & output from SQL Agent
  - 5
    - Can't install sql server 2005 This typically is an issue of a missing file association for the hta extension. To manually make the association, open Windows Explorer. From the Tools menu select Folder Options. From the Folder Options dialog select the File Types tab. Scroll down to see if there is an entry for HTA. Under File Types for HTA it should say "HTML Application". The associated information should be: Action: Open Application used to perform action: C:\WINDOWS\System32\mshta.exe "%1" %* Use DDE: On Application: mshta Topic: System Thanks, Samuel Lester (MSFT) Tag: Reporting errors & output from SQL Agent
  - 6
    - ReportServicesConfigUI.WMIProvider.WMIProviderException: System.Runtime.InteropServices.COMException (0x8000000A) Did you find a solution for this I'm getting the same thing. Andy Tag: Reporting errors & output from SQL Agent
  - 7
    - Creating a Sum for the Year Try: GROUP BY Year([Date]), Month([Date]) If you only group on the month, then, for example, May 2006 would be grouped with May 2005. Tag: Reporting errors & output from SQL Agent
  - 8
    - New User - Unable to connect It sounds like you're running Express Edition. Is that correct If so, you need to enable remote connections since they are turned off by default. This page will walk you through it: http://support.microsoft.com/kb/914277 Thanks, Sam Lester (MSFT) Tag: Reporting errors & output from SQL Agent
  - 9
    - problem deploying SSIS to another server. Not sure, but have you checked that the SQL Server Integration Services service is running on the target machine Tag: Reporting errors & output from SQL Agent
  - 10
    - Check remotely if Reporting Services exist What do you actually Mean by checking reporting Services remotely What is your requirement Tag: Reporting errors & output from SQL Agent
  - 11
    - File Move Component Error The error is comming straight from the operating system, and seems fair enough. You could engineer a package that re-tried with a loop, but actually I'd be tempted to do that in a Script Task. You would have to decide how long to wait for as well. Perhaps it would be better to determine the cause of the open file. Add a call to handle and pipe the contents to a log file so you can review when it fails next http://www.microsoft.com/technet/sysinternals/utilities/handle.mspx Tag: Reporting errors & output from SQL Agent
  - 12
    - Error deploying large Report Model What is the size You want to go behind the maxRequestLength setting and increase it till you are able to deploy. http://msdn2.microsoft.com/en-us/library/e1f13641(VS.80).aspx speaks in detail about HTTPRuntimes Tag: Reporting errors & output from SQL Agent
  - 13
    - Barcode doesn't print from reports server Can you tell me how you got the labels to print correctly. I can't seem to get mine lined up. I am trying to print Avery 5160 which is also 30 labels. Thanks Crystal Tag: Reporting errors & output from SQL Agent
  - 14
    - Copy cube from a DB to another one Hello! You have not told about what version you are using, AS2000 or SSAS2005 With SSAS2005 you simply change this is the properties of the project and deployment. This is in the solution explorer of BI-Developer Studio. In AS2000 you can use archive and restore from one machine to another as long as the data source name is the same. Regards Thomas Ivarsson Tag: Reporting errors & output from SQL Agent
  - 15
    - How to change the instance name? There is not a supported way to rename an instance. You need to uninstall and then reinstall. Thanks, Peter Saddow Tag: Reporting errors & output from SQL Agent
  - 16
    - Database size allocation - where other than tables, logs, etc ???? sp_spaceused can give you some details about data space. sp_helpfile will show data and log file sizes. You may just need to shrink your database to get the file sizes down using DBCC SHRINKDATABASE or SHRINKFILE. Tag: Reporting errors & output from SQL Agent

_jesse

I'm scheduling a T-SQL job with SQL Agent. The job uses PRINT to write out various progress and status messages as it runs. I created an Operator, and set a Notification when the job fails -- will that send me the entire output of the job, or just the error message

Top

Re: Reporting errors & output from SQL Agent

Sue Hoegemeier

You will just get notification that the job failed.

If you want the details, I think what you are looking for is to use an output file for the job and then attach and send that file with the job failure. For the output file, click on the job step (or steps) and and go to the advanced windows where you can designate and output file.

-Sue

Top