Top "Sql-server-agent" questions

How do I create a SQL Server agent without using a GUI?

I am using Angel LMS and its built on a SQL Server platform. I believe its 2005, but not 100% sure about …

sql command-line transactions sql-server-agent agent

Access to the remote server is denied because the current security context is not trusted, SQL server agent

I execute the following statements on the management studio perfectly, with out any problem. Execute sp_addlinkedserver 'remoteservername' execute sp_…

sql-server tsql sql-server-2012 sql-server-agent

SQL Agent: Set a Max Execution Time

Afternoon. I have several SQL Agent jobs running on an MS 2K8 BI server, some of them on a daily …

sql-server sql-server-agent

SQL Server Agent Job is not running

I have a job that is supposed to run every 11 AM and 8 PM. About two weeks ago, it started to …

sql sql-server-agent sql-job

Deploying SSIS Package and retaining a connection password

I have an SSIS package that queries a view for some records then sends off an email using Database mail. …

sql-server ssis sql-server-agent

Analysis Services Processing Task Fails When Run By SQL Server Agent

I have an SSIS package which contains an Analysis Services Processing Task. This package is kicked off by a SQL …

ssis sql-server-2008-r2 ssas sql-server-agent

Stored Procedure Return Value to Fail SQL Job

I have a stored procedure which is the first step in an SQL Job. The SP compares dates in 2 tables, …

sql sql-server stored-procedures return-value sql-server-agent

Everytime I start SQL Server Agent job I get an error log

Every time I start an Sql Server job, I get the following error. I am using SQL Server 2016. Does not …

sql-server-agent sql-server-2016