1

So, I've created a SQL Server Agent job, according to the answer to my prev question:

General

Advanced

enter image description here

running nightly (at 2:11) according to the schedule:

Nightly Schedule

There are 9 .bak files in 3 subdirectory of d:\backup\ source folder, 3 old bakup files are being deleted and 3 new is being created by another preceding SQL Server Agent job.

The described here job copy-purges files but... what the heck the history of this Copy&Purge BAKs SQL ServerAgent job shows 96 items:

enter image description here

How to make it less verbose?

Eventvwr.msc doesn't contain any eroors for the corresponding period of time (of job run).

UPDATE:

So, I've made these changes

enter image description here

and it seems it simply truncates a per-job log:

enter image description here

3 Answers3

3

Perhaps you need to uncheck this:

enter image description here

The job step properties screen allows you to prevent the output from the job being recorded in the job history.

Hannah Vernon
  • 70,928
  • 22
  • 177
  • 323
3

If I understand correctly, the job step history is recording all of the output from the robocopy command. How about adding suppression arguments to the command line? From the Robocopy topic on TechNet:

/ns  -- Specifies that file sizes are not to be logged.
/nc  -- Specifies that file classes are not to be logged.
/nfl -- Specifies that file names are not to be logged.
/ndl -- Specifies that directory names are not to be logged.
/np  -- Specifies that the progress of the copying operation (the number 
        of files or directories copied so far) will not be displayed.

See also: the official docs

Peter Vandivier
  • 5,485
  • 1
  • 25
  • 49
Aaron Bertrand
  • 181,950
  • 28
  • 405
  • 624
1

not sure if you just wanted to reduce the number of rows shows up there or actually want SQL server Agent not to log that much of data. but if it is to limit the number of rows to log per job and/or total in job history then you can set those from SSMS as shown below.

enter image description here

Anup Shah
  • 642
  • 1
  • 6
  • 9