Top "Sql-agent-job" questions

How to accurately detect if a SQL Server job is running and deal with the job already running?

I'm currently using code like this to detect if a SQL server job is running. (this is SQL Server 2005, all …

sql-server tsql sql-server-agent sql-agent-job
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
SSIS package fails in sql server agent, but not in visual studio. ODBC Connection

I have an SSIS package that runs fine in visual studio 2010, but as a job it sql server it fails …

sql-server visual-studio-2010 ssis sql-agent-job
Run C# code inside a SQL Agent Job

I have a piece of code that needs to run every day at a specified time. The code right now …

c# sql-server sql-agent-job
SSIS Package error- SSIS Error Code DTS_E_PROCESSINPUTFAILED

SSIS job has failed and posting the below error [Product Sales [749]] Error: An exception has occurred during data insertion, the …

sql-server ssis etl ado sql-agent-job
SQL Server Agent not starting automatically on server reboot

I have noticed that SQL Agent does not start automatically after a reboot/shutdown on a few of our servers (…

sql sql-server sql-server-2008 windows-server-2008 sql-agent-job
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
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
Need to start agent job and wait until completes and get success or failure

I have been trying to find sample code with using SQL Server 2005, I need to start an Agent Job and …

tsql sql-server-2005 sql-agent-job
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