I have created a job with several SSIS packages included in it. There is a failure when I schedule and run the job. Where can I find the information why it is failing When I run the packages individually, they run fine. Thanks in advance.
SQL Agent Failure
Hot Topic
- "Launch Database Mirroring Monitor" is not an option
- pagesize of report is much larger than expected when printed
- Selecting ProfileName to use by the SQLMERGXLib.SQLMerge
- Unable to create database from VS
- Handling null in a result
- oracle connection manager configuration help
- Query Log File and Usage Based Optimization
- Serious Converting Data Problem
- New database from backup
- Looping through an excel spreadsheet
SQL Server
- How to do Minof max and maxof min Calculation in SQL
- Decoding Decimal Form of HRESULT from ErrorCode
- DateTime parameter format
- Link 2 servers over web - best method query
- SQL 2000 Not Really Gone
- What interface does Management Studio use?
- Running multiple instances of the same package in parallel
- creating an adjacency list from a parent - child table
- Avoiding deadlock
- About Login Account
SQL Agent Failure
François Paradis
http://support.microsoft.com/kb/918760
Please check it out.
JBABumper
Presumably you are using a log provider in your packages so first thing to do would be to look at those logs.
Also, use command-line job step to execute the package. http://wiki.sqlis.com/default.aspx/SQLISWiki/ScheduledPackages.html
-Jamie