HiveBrain v1.2.0
Get Started
← Back to all entries
principlesqlMinor

Stored procedures vs inline SQL in a Job step

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
storedproceduressqlstepinlinejob

Problem

I have created a job with two steps:

  • Delete 50000 rows from an error table older than 90 days.



-
Create and email a quick report on the number of new records created in the error table that day, literally a:

SELECT count_big(*) 
FROM table
WHERE datevalue  DATEADD(DAY,-1,GETUTCDATE())


...but with some happy formatting to make an email table.

Currently I have step 2 running SQL in the job step rather than calling a stored procedure.

My question is, does it make a difference (performance or otherwise) in SQL Server 2014, to run a job step that calls a stored procedure or one that executes inline SQL?

Solution

does it make a difference (performance or otherwise) in SQL Server 2014, to run a job step that calls a stored procedure or one that executes inline sql?

In your case, since you are just doing reporting, it won't make much difference either using inline SQL or a stored procedure.

Aaron Bertrand provides a really good answer to a related question:

Stored procedures vs. inline SQL

Context

StackExchange Database Administrators Q#97801, answer score: 3

Revisions (0)

No revisions yet.