Top "Sql-agent" questions

SQL agent, also known as SQL server agent, is a Microsoft SQL server relational database management system (RDBMS) background tool.

how to know status of currently running jobs

I need to know if a given Job is currently running on Ms SQL 2008 server. So as to not to …

sql-server sql-server-2008 tsql sql-agent
How can I view full SQL Job History?

In SQL Server Management Studio, when I "View History" for a SQL Job, I'm only shown the last 50 executions of …

sql-server ssms history sql-job sql-agent
SQL SERVER Agent stops working Automatically

I have been experiencing a strange issue for last few weeks. On my two different servers the sql server Agent …

sql-server sql-server-2008-r2 sql-agent
How to succesfully run a batch file in an SQL Agent job?

Dear Stackoverflow users, I have a SQL Agent Job which generates a specific report in PDF-file and then copies the …

sql-server-2008 batch-file jobs sql-agent
SQL Server Agent - get my own job_id

I'm running a SQL Server 2008 64 bit Developer Edition with Service Pack 1 installed. I have a SQL Server Agent Job. Within …

sql-server sql-agent sql-agent-job
Executing SSIS Package as SQLAgent Job

I have a SQL Server 2008 SSIS job which executes some Win 32 exe files. This job runs fine when i execute …

sql-server sql-server-2008 ssis sql-agent
SQL Server Agent Adding a Parameter for a CmdExec

I want to add a parameter to a step that runs an operating system (CmdExec) in SQL Server Agent. I …

sql-server-2008 sql-agent sql-agent-job
SSIS DTS Package flat file error - "The file name specified in the connection was not valid"

I have a pretty basic SSIS package that is attempting to read a file hosted on a share, and import …

sql-server-2005 ssis sql-agent
Query to list the job names and step associated with a particular table

Is there any way to search and find ,what job holds a particular table refresh . There are multiple sql agent …

sql sql-server sql-agent-job sql-agent
SQL Server Agent Job Running Slow

I am executing a stored procedure using SQL Server Agent Job in SQL Server 2005. This job was running fast until …

sql-server sql-server-2005 sql-agent-job sql-agent