Does the Sql Server Express include Sql Server Agent??

Ramon Quintana

7y18.8k

Hi,

I have a question, Does the Sql Server Express include Sql Server Agent??

or do i have to install a stand alone SQL Agent?? if it so, what site do you recomend me to do it..

Thank out there!!

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nirav Gandhi7y ago
No.SQL express does not have SQL agent but you can use Task scheduler to scedule your job.

You will get all features details avaiable in express edition from below link:-

https://www.microsoft.com/en-us/sql-server/sql-server-2017-editions
0
Ramon Quintana7y ago
Here the .bat:

echo off

sqlcmd -S MD1Z7UGC\SQLEXPRESS02 -d 1RQ_BPCSQL1 -E -i C:\BPC\Procesos_Almacenados\SQLQuery3.sql

set /p delExit=Presione una tecla para salir...:

and here the .sql: "JUST A INSERT INTO A TABLE"
USE [1RQ_BPCSQL1]
GO
/****** Object: StoredProcedure [dbo].[Proceso_Reporte2] Script Date: 30/05/2019 1:53:05 p. m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Proceso_Reporte2]
@Num_Cta_INI nvarchar(8),
@Num_Cta_FIN nvarchar(8),
@Trans_Type nvarchar(8)
AS
SET NOCOUNT ON;
----insert a record into a table ----------------
insert into dbo.Resultado_Proceso1 (RESULTADO)
select concat (F32,' ',F27,' ',F26,' ',F25,' ',F24,' ',F23,' ',F22,' ',F21,' ',F20,' ',F19,' ',F18,' ',F17,' ',F16,' ',F15,' ',F14,' ',F13,' ',F12,' ',F11,' ',F10,' ',F9,' ',F8,' ',F7,' ',F6,' ',F5,' ',F4,' ',F3,' ',F2) as Result
FROM [1RQ_BPCSQL1].[dbo].[ProcesoReporteKOMBI]
WHERE Trans_Type =@Trans_Type and f33 < @Num_Cta_INI and F34 > @Num_Cta_FIN

Thank if you can HELP PLEASE
0
Ramon Quintana7y ago
Hi,

I got this error after try to run .bat from Task Schedule:

0
Sonu Gupta7y ago
Hi,

No. SQL Server Express Edition is a free version that does not include the SQL Agent (because it is free).

More detail about the SQL Server Agent please navigate to below given URL

https://www.sqlshack.com/faq-and-examples-about-the-sql-server-agent/

+2
Bidyasagar Mishra7y ago
yes, its included .
For work on this follow the link
https://stackoverflow.com/questions/7201061/how-to-create-jobs-in-sql-server-express-edition
+1