You can use sp_update_jobstep.  Are you sure you can't do it in SSMS?  If you open the properties tab of the step in question you can edit the Step...

• This reply was modified 3 years, 11 months ago by  Neil Burton.
• This reply was modified 3 years, 11 months ago by  Neil Burton.

My boss manually deleted the backlog in chunks on Friday and things appear to have been fine over the weekend.  I'll know a bit more definitely when the...

Found out the other week, we're likely to be working from home to the end of June 2021...

So I splurged and bought myself a new, more adjustable desk chair...

Well, that took a tangent...

Thanks for your input gents.  I'd done some poking about and I'd couldn't find what was calling the task anywhere.  I did find the proc that...

Typical WYPIWYG, what you pay is what you get.

😎

The number of rows limitation just tells us that someone is using an old version of...

Well this is awkward.

• This reply was modified 4 years, 1 month ago by  Neil Burton.

WITH Numbers AS
(

SELECT  CAST(ROW_NUMBER() OVER(ORDER BY(SELECT NULL)) AS decimal(8,2)) AS N  
FROM
(VALUES(1),(1),(1),(1),(1),(1),(1),(1),(1),(1))t(N)--10 Rows
CROSS JOIN (VALUES(1),(1),(1),(1),(1),(1),(1),(1),(1),(1))t1(N) --100 Rows
CROSS JOIN (VALUES(1),(1),(1),(1),(1),(1),(1),(1),(1),(1))t2(N) --1000 Rows
/**********Add these lines in if...

You're welcome Paul.

That query will produce up to 1000 rows if needs be just by changing the '<=500' to what you want.

Have you copied all of the query? It should be returning 500 rows.  The last line is 'WHERE N<= 500'.

I'm not sure what...

WITH Numbers  AS
(
SELECT  CAST(ROW_NUMBER() OVER(ORDER BY(SELECT NULL)) AS decimal(8,2)) AS N
FROM
(VALUES(1),(1),(1),(1),(1),(1),(1),(1),(1),(1))t(N)
CROSS JOIN (VALUES(1),(1),(1),(1),(1),(1),(1),(1),(1),(1))t1(N)
CROSS JOIN (VALUES(1),(1),(1),(1),(1),(1),(1),(1),(1),(1))t2(N)
)
SELECT 
N-0.99 AS Lower
,NAS Upper

FROM

Numbers
WHERE N<= 500

Does that work?

I've done a bit of research and experimenting on this and I think I've worked out what's happening.  I've got a theory as to why but I shouldn't take as...

What's worse: a problem which starts spontaneously and for which nobody is able to track down the cause, or, the same problem spontaneously stopping over the weekend and nobody having...

There's a joke that's been going around about Trump since day one of his time in office.  I have no great love for the man (nor any of politicians currently...

• This reply was modified 4 years, 6 months ago by  Neil Burton.

Heh... let the silliness continue.  I just got an email saying...

KILL 99.9% OF BACTERIA & HARMFUL MICROBES

FORMS A PROTECTIVE SHIELD THAT DELAYS GROWTH OF HARMFUL MICROBES ON INTERIOR SURFACES

Reg...