API tools faq
paste
Advertisement
gasguirre

log sql server agent

gasguirre
Oct 18th, 2019
3,263
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Logtalk 9.71 KB | None | 0 0
raw download clone embed print report
  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.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!