1

Topic: The job has been stopped before performance... Help... I the Programmer 1, not SQL-shchik.

Problem in the following:
MSEC SQL the server 2014, are available jobs in the Agent of the server on archive copying of working basis, all worked to 3/6/2018, someone there was engaged with the server, even asked not to come any time and after that some jobs SOME ceased to be carried out, one job both worked. And works, and others two do not work, even when manually I launch "to Launch the job for a step". It is not launched. It like as is launched, but hangs indefinitely while itself I will not remove. Something can with the User from which name there is a start? Can it is right what does not suffice? Why does not inform then on it. Produces the message: "the Job has been stopped before performance the User (such)... Job Start has been produced the Schedule (such)... The step 1 was the Last executable step..." Thus the archive file and did not form (even a label), though the triggered job hung (while itself did not remove) 7  50 mines 41 seconds
What can be? Help!!!

2

Re: The job has been stopped before performance... Help... I the Programmer 1, not SQL-shchik.

Look, that waited by the job.
sys.dm_os_waiting_tasks

3

Re: The job has been stopped before performance... Help... I the Programmer 1, not SQL-shchik.

Yasha123, and how to launch? I in Management  create sql request and I fulfill, produces an error.

4

Re: The job has been stopped before performance... Help... I the Programmer 1, not SQL-shchik.

Mar_tin;
These  you did or to you someone made?
At you there DBA is?

5

Re: The job has been stopped before performance... Help... I the Programmer 1, not SQL-shchik.

The grandfather,
Itself did, all worked perfectly, I and on other servers too did them once, such was never...

6

Re: The job has been stopped before performance... Help... I the Programmer 1, not SQL-shchik.

The grandfather, here the job on
DECLARE @DBname VARCHAR (1000) - a basis title
DECLARE @path VARCHAR (1000) - a way  SQL
DECLARE @path2 VARCHAR (1000) - an archive way rar
DECLARE @CMDStr VARCHAR (1000) - a line of a command for
-- Parameters  are adjusted here:
SET @path = ' D:\BACKUP\B\8_KA _ ' + CONVERT (VARCHAR (8), Getdate (), 112) + ' _ ' + REPLACE (CONVERT (CHAR (8), Getdate (), 108), ': ', ' _ ')
SET @path2 = @path + '.rar'
SET @path = @path + '.bak'
-- Let's delete all previous SQL , and leaking let remains before next run
SET @CMDStr = ' forfiles/P "D:\BACKUP\B"/M *.bak/S/D-0/C "cmd/c del/q @path"'
EXEC xp_cmdshell
@CMDStr
-- Basis title to specify here!
BACKUP database [KA _] TO disk = @path
SET @CMDStr = ' "RAR a-y-dh-ep-m2-mt2-rr [5] ' + @path2 + ' ' + @path
EXEC xp_cmdshell
@CMDStr
GO

7

Re: The job has been stopped before performance... Help... I the Programmer 1, not SQL-shchik.

Mar_tin wrote:

Yasha123 and how to launch? I in Management  create sql request and I fulfill, produces an error.

select s.login_name,
wt.*
from sys.dm_os_waiting_tasks wt
join sys.dm_exec_sessions s
on wt.session_id = s.session_id
where s.is_user_process = 1 and s.session_id <> @@ spid
order by wt.session_id;

8

Re: The job has been stopped before performance... Help... I the Programmer 1, not SQL-shchik.

Yasha123;
The message 2809, level 16, state 1, line 1
Performance of request procedure "dm_os_waiting_tasks" terminated unsuccessfully as "dm_os_waiting_tasks" representation is object.
(Lines it is processed: 2)
The request is completed with errors.

9

Re: The job has been stopped before performance... Help... I the Programmer 1, not SQL-shchik.

wrote:

- we delete all previous SQL , and leaking let remains before next run
SET @CMDStr = ' forfiles/P "D:\BACKUP\B"/M *.bak/S/D-0/C "cmd/c del/q @path"'
EXEC xp_cmdshell
@CMDStr

You here it delete all available .
I.e. for a moment, when still the new is not made;
At you already generally any  does not remain.
Well and now .
Also what will do?

10

Re: The job has been stopped before performance... Help... I the Programmer 1, not SQL-shchik.

I am sorry, there the old line remained was, deleted it and fulfilled, errors did not show more, now I will launch the job and I will repeat...
I will unsubscribe...

11

Re: The job has been stopped before performance... Help... I the Programmer 1, not SQL-shchik.

Mar_tin wrote:

Yasha123;
The message 2809, level 16, state 1, line 1
Performance of request procedure "dm_os_waiting_tasks" terminated unsuccessfully as "dm_os_waiting_tasks" representation is object.
(Lines it is processed: 2)
The request is completed with errors.

Instead of it is necessary to highlight this poor dm_os_waiting_tasks;
When fulfill.
All code select or generally select nothing, when fulfill

12

Re: The job has been stopped before performance... Help... I the Programmer 1, not SQL-shchik.

Yasha123;
Thanks, like understood...  I will check up...

13

Re: The job has been stopped before performance... Help... I the Programmer 1, not SQL-shchik.

No, commented out these lines, all is not launched

14

Re: The job has been stopped before performance... Help... I the Programmer 1, not SQL-shchik.

Yasha123, here result at the triggered and hanging job:
login_name waiting_task_address session_id exec_context_id wait_duration_ms wait_type resource_address blocking_task_address blocking_session_id blocking_exec_context_id resource_description
sa 0x000001C9B23B6108 59 2 687 BACKUPBUFFER NULL NULL NULL NULL NULL
sa 0x000001C998F324E8 59 0 48313970 ASYNC_IO_COMPLETION 0x0000000000000001 NULL NULL NULL NULL
NT SERVICE\SQLSERVERAGENT 0x000001C94A02A4E8 68 0 12191 LCK_M_U 0x000001C9C1AD1F80 0x000001C998F324E8 59 NULL databaselock subresource=BULKOP_BACKUP_DB dbid=5 lockPartition=0 id=lock1c9c7d86d80 mode=U

15

Re: The job has been stopped before performance... Help... I the Programmer 1, not SQL-shchik.

Mar_tin;

Mar_tin wrote:

LCK_M_U 0x000001C9C1AD1F80 0x000001C998F324E8 59 NULL databaselock subresource = BULKOP_BACKUP_DB

the last paragraph of section Symptoms

16

Re: The job has been stopped before performance... Help... I the Programmer 1, not SQL-shchik.

17

Re: The job has been stopped before performance... Help... I the Programmer 1, not SQL-shchik.

The grandfather;
Strange, even manually it was not launched and it was suddenly launched, something with basis probably, can it is occupied was, and here it was released from something.
That job, which itself starts, to bases is not connected.
And with other auxiliary bases too always manually started, there there is no start under the schedule.
Something with working basis, not with the user and not with the rights... But here that? People work with it, as well as always worked...

18

Re: The job has been stopped before performance... Help... I the Programmer 1, not SQL-shchik.

wrote:

Mar_tin;
it is passed...
the last paragraph of section Symptoms

To put it briefly;
Already another hangs .
And all  the data (i.e. full or diff) are built in queue;
Expecting end begun before .
I.e. you should understand with

19

Re: The job has been stopped before performance... Help... I the Programmer 1, not SQL-shchik.

Mar_tin wrote:

Is not present, commented out these lines, all is not launched

That my comment not about that,
Why it is not launched;
And about that;
That is bad to delete all  still before;
As the next is made.
For while all is remote, and new still is not present;
You generally sit without uniform .
And if the server is screwed during this moment;
You remain without

20

Re: The job has been stopped before performance... Help... I the Programmer 1, not SQL-shchik.

Mar_tin wrote:

;
Strange, even manually it was not launched and it was suddenly launched, something with basis probably, can it is occupied was, and here it was released from something.
...
Something with working basis, not with the user and not with the rights... But here that? People work with it, as well as always worked...

Well so that ended  that before did not allow to be fulfilled remaining

21

Re: The job has been stopped before performance... Help... I the Programmer 1, not SQL-shchik.

Mar_tin wrote:

here, the translator translated the last paragraph about what to me does not speak:

in the end of article the reason of an event is written and even the code piece is resulted

22

Re: The job has been stopped before performance... Help... I the Programmer 1, not SQL-shchik.

Yasha123;
Files with.bak extension with.rar extension are deleted only remain, it it is necessary not to litter with huge not oblate files a disk space, not to double with archive same (the size a tank of a file of 99 Ggb, and  - 4.5 Ggb). One not oblate file remains for days, thus the whole day long I have possibility, not , to have possibility to recover it in test basis, next day there will be always a fresh morning copy of basis, it is not necessary to waste time (huge) on dearching each time if needed copy restitutions in test basis (for my debug operations).

23

Re: The job has been stopped before performance... Help... I the Programmer 1, not SQL-shchik.

In other words, was so earlier: after working off ,  the copy (I deleted this text) at once was deleted,
Now it remains before following copying (and before it of removal), but remaining all will be deleted (and except one last there is nothing to delete, others and will not be)

24

Re: The job has been stopped before performance... Help... I the Programmer 1, not SQL-shchik.

All thanks, all earned, probably the reason was at a distance a file tank at once after its creation that caused hangup.

25

Re: The job has been stopped before performance... Help... I the Programmer 1, not SQL-shchik.

For everything, except the HARDWARE (it persistently ignores, the hell with him):
The reason was that simultaneously cannot be fulfilled 2  the data.
While one is fulfilled, the second hangs with waiting LCK_M_U subresource=BULKOP_BACKUP_DB