SHARE
TWEET

log sql server agent

gasguirre Oct 18th, 2019 123 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. #Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message
  2. OnPreValidate,**DESTINATION**,**SqlServerAgent**,Package,{77F5FBE5-0995-4B8D-A498-34575FFF2E62},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,
  3. OnPreValidate,**DESTINATION**,**SqlServerAgent**,copy from **ORIGIN** to **DESTINATION**,{3c05ac51-5cf5-4c80-a4a2-e55b8aa4c980},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,
  4. OnPostValidate,**DESTINATION**,**SqlServerAgent**,copy from **ORIGIN** to **DESTINATION**,{3c05ac51-5cf5-4c80-a4a2-e55b8aa4c980},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,
  5. OnPreValidate,**DESTINATION**,**SqlServerAgent**,copy to archive in **DESTINATION**,{c69b588e-70fa-4bfc-b366-5ba903d7b37e},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,
  6. OnPostValidate,**DESTINATION**,**SqlServerAgent**,copy to archive in **DESTINATION**,{c69b588e-70fa-4bfc-b366-5ba903d7b37e},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,
  7. OnPreValidate,**DESTINATION**,**SqlServerAgent**,move to archive in **ORIGIN**,{45bedf59-6f24-4d58-965a-99770db3569a},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,
  8. OnPostValidate,**DESTINATION**,**SqlServerAgent**,move to archive in **ORIGIN**,{45bedf59-6f24-4d58-965a-99770db3569a},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,
  9. OnPreValidate,**DESTINATION**,**SqlServerAgent**,rename file,{f32e692c-8880-479e-b091-4a3ac93ad1d5},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,
  10. OnPostValidate,**DESTINATION**,**SqlServerAgent**,rename file,{f32e692c-8880-479e-b091-4a3ac93ad1d5},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,
  11. OnPreValidate,**DESTINATION**,**SqlServerAgent**,copy from **ORIGIN** to **DESTINATION**,{9438F5BF-03F9-4B06-A839-013509C9CA4F},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,
  12. OnPostValidate,**DESTINATION**,**SqlServerAgent**,copy from **ORIGIN** to **DESTINATION**,{9438F5BF-03F9-4B06-A839-013509C9CA4F},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,
  13. OnPreValidate,**DESTINATION**,**SqlServerAgent**,copy to archive in **DESTINATION**,{e4a2d5ec-210c-4186-b5d2-9b267d8be507},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,
  14. OnPostValidate,**DESTINATION**,**SqlServerAgent**,copy to archive in **DESTINATION**,{e4a2d5ec-210c-4186-b5d2-9b267d8be507},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,
  15. OnPreValidate,**DESTINATION**,**SqlServerAgent**,move to archive in **ORIGIN**,{a3879149-ff8b-44f8-853e-125a650168a5},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,
  16. OnPostValidate,**DESTINATION**,**SqlServerAgent**,move to archive in **ORIGIN**,{a3879149-ff8b-44f8-853e-125a650168a5},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,
  17. OnPreValidate,**DESTINATION**,**SqlServerAgent**,rename file,{390b2de9-7b8f-44e1-9eed-89a4088a5273},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,
  18. OnPostValidate,**DESTINATION**,**SqlServerAgent**,rename file,{390b2de9-7b8f-44e1-9eed-89a4088a5273},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,
  19. PackageStart,**DESTINATION**,**SqlServerAgent**,Package,{77F5FBE5-0995-4B8D-A498-34575FFF2E62},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,Beginning of package execution.
  20.  
  21. Diagnostic,**DESTINATION**,**SqlServerAgent**,Package,{77F5FBE5-0995-4B8D-A498-34575FFF2E62},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,Based on the system configuration, the maximum concurrent executables are set to 10.
  22.  
  23. DiagnosticEx,**DESTINATION**,**SqlServerAgent**,Package,{77F5FBE5-0995-4B8D-A498-34575FFF2E62},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,<?xml version="1.0"?><DTS:ParameterValues xmlns:DTS="www.microsoft.com/SqlServer/Dts"><DTS:PackageParameter DTS:DataType="8" DTS:ObjectName="**DESTINATION**_Oracle_Labour" DTS:DTSID="{D2FD2E9C-B341-4DD3-A133-0329E721377B}" DTS:CreationName=""><DTS:Property DTS:Name="ParameterValue" DTS:DataType="8">\\**DESTINATION**\labour</DTS:Property></DTS:PackageParameter><DTS:PackageParameter DTS:DataType="8" DTS:ObjectName="**DESTINATION**_Oracle_Labour_ARCHIVE" DTS:DTSID="{435F186A-D269-454F-8871-92DDA2792EEF}" DTS:CreationName=""><DTS:Property DTS:Name="ParameterValue" DTS:DataType="8">\\**DESTINATION**\labour\Archive</DTS:Property></DTS:PackageParameter><DTS:PackageParameter DTS:DataType="8" DTS:ObjectName="**DESTINATION**_Oracle_Labour_GL" DTS:DTSID="{7807BCE4-900F-4DBE-8071-D30DD894897D}" DTS:CreationName=""><DTS:Property DTS:Name="ParameterValue" DTS:DataType="8">\\**DESTINATION**\labour\gl</DTS:Property></DTS:PackageParameter><DTS:PackageParameter DTS:DataType="8" DTS:ObjectName="**DESTINATION**_Oracle_Labour_GL_ARCHIVE" DTS:DTSID="{633217C2-9226-4B73-A750-D02371C149BD}" DTS:CreationName=""><DTS:Property DTS:Name="ParameterValue" DTS:DataType="8">\\**DESTINATION**\labour\gl\Archive</DTS:Property></DTS:PackageParameter><DTS:PackageParameter DTS:DataType="8" DTS:ObjectName="**ORIGIN**_Oracle_ARCHIVE" DTS:DTSID="{97EB37CD-8030-4F13-9F67-686D99ACAA26}" DTS:CreationName=""><DTS:Property DTS:Name="ParameterValue" DTS:DataType="8">\\**ORIGIN**\oracle\Archive</DTS:Property></DTS:PackageParameter><DTS:PackageParameter DTS:DataType="8" DTS:ObjectName="**ORIGIN**_Oracle_START" DTS:DTSID="{221FA746-7F5F-40D9-A6EE-A129681061E5}" DTS:CreationName=""><DTS:Property DTS:Name="ParameterValue" DTS:DataType="8">\\**ORIGIN**\oracle</DTS:Property></DTS:PackageParameter><DTS:PackageParameter DTS:DataType="8" DTS:ObjectName="Rename_to_glcosts_bcp" DTS:DTSID="{73DDD646-6128-43CC-BBB4-8BFF9BA6BFB2}" DTS:CreationName=""><DTS:Property DTS:Name="ParameterValue" DTS:DataType="8">\\**DESTINATION**\labour\gl\glcosts.bcp</DTS:Property></DTS:PackageParameter><DTS:PackageParameter DTS:DataType="8" DTS:ObjectName="Rename_to_labourcosts_bcp" DTS:DTSID="{AAD15AA7-0BB1-46AA-8743-E4565BB2A782}" DTS:CreationName=""><DTS:Property DTS:Name="ParameterValue" DTS:DataType="8">\\**DESTINATION**\labour\labourcosts.bcp</DTS:Property></DTS:PackageParameter></DTS:ParameterValues>
  24. OnPreExecute,**DESTINATION**,**SqlServerAgent**,Package,{77F5FBE5-0995-4B8D-A498-34575FFF2E62},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,
  25. OnPreExecute,**DESTINATION**,**SqlServerAgent**,Operate with the OracleFinal_GL,{AAC61EB1-03BA-4332-B85E-8E7056281DD4},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,
  26. OnWarning,**DESTINATION**,**SqlServerAgent**,Operate with the OracleFinal_GL,{AAC61EB1-03BA-4332-B85E-8E7056281DD4},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,-2147368956,0x,The For Each File enumerator is empty. The For Each File enumerator did not find any files that matched the file pattern, or the specified directory was empty.
  27.  
  28. OnWarning,**DESTINATION**,**SqlServerAgent**,Package,{77F5FBE5-0995-4B8D-A498-34575FFF2E62},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,-2147368956,0x,The For Each File enumerator is empty. The For Each File enumerator did not find any files that matched the file pattern, or the specified directory was empty.
  29.  
  30. OnPostExecute,**DESTINATION**,**SqlServerAgent**,Operate with the OracleFinal_GL,{AAC61EB1-03BA-4332-B85E-8E7056281DD4},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,
  31. OnPreExecute,**DESTINATION**,**SqlServerAgent**,Operate with the OracleFinal,{3899686b-c02b-4622-9305-882b8517310d},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,
  32. OnWarning,**DESTINATION**,**SqlServerAgent**,Operate with the OracleFinal,{3899686b-c02b-4622-9305-882b8517310d},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,-2147368956,0x,The For Each File enumerator is empty. The For Each File enumerator did not find any files that matched the file pattern, or the specified directory was empty.
  33.  
  34. OnWarning,**DESTINATION**,**SqlServerAgent**,Package,{77F5FBE5-0995-4B8D-A498-34575FFF2E62},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,-2147368956,0x,The For Each File enumerator is empty. The For Each File enumerator did not find any files that matched the file pattern, or the specified directory was empty.
  35.  
  36. OnPostExecute,**DESTINATION**,**SqlServerAgent**,Operate with the OracleFinal,{3899686b-c02b-4622-9305-882b8517310d},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,
  37. OnPostExecute,**DESTINATION**,**SqlServerAgent**,Package,{77F5FBE5-0995-4B8D-A498-34575FFF2E62},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,
  38. DiagnosticEx,**DESTINATION**,**SqlServerAgent**,Package,{77F5FBE5-0995-4B8D-A498-34575FFF2E62},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,<?xml version="1.0"?><DTS:ProcessMemoryUsage xmlns:DTS="www.microsoft.com/SqlServer/Dts"><DTS:PeakWorkingSetSize>32571392</DTS:PeakWorkingSetSize></DTS:ProcessMemoryUsage>
  39. PackageEnd,**DESTINATION**,**SqlServerAgent**,Package,{77F5FBE5-0995-4B8D-A498-34575FFF2E62},{CD5E6DF7-DB3F-449A-B45E-8CABF62BCF17},10/18/2019 10:22:50 AM,10/18/2019 10:22:50 AM,0,0x,End of package execution.
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top