Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Job/step error in SQL Server 2005 + no log file created

Status
Not open for further replies.

luzippu

Programmer
Sep 2, 2003
24
GB
----------------------
MS Win XP Pro 2002 SP2
MS SQL Server 2005
MS Visual Studio 2005
----------------------

I'm trying to schedule a job in Management Studio (SQL Server Agent)for a SSIS package that runs fine in BI Visual Studio and that also runs ok if executed from Management Studio connected to Integration Services (Stored Packages\MSDB\Maintenace Plans\Package1)

I've tried to set up a log file (provider for text files with all events ticked) but this is all i get: "OnPreValidate,UKSERV01,NT AUTHORITY\SYSTEM,PACKAGE1,{A9D28A92-C509-4F1D-9630-0848B0036929},{FF9D650E-62D3-44F1-9D76-B34467E8DADC},01/09/2006 16:46:09,01/09/2006 16:46:09,0,0x,(null)"

I'm the only user on this pc, thus Server Name, Creator, Author etc. always refer to the same parameters.

Any help will be appreciated.
thank you


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top