Top "Sql-server-agent" questions

SQL Server Agent is a Microsoft Windows service that executes scheduled administrative tasks, which are called jobs.

How to backup SQL Server Agent jobs?

How can I backup and restore SQL Server 2005 Agent job schedules?

sql-server sql-server-2005 ssis backup sql-server-agent
SQL Server Agent Job Timeout

I have just had a scheduled SQL Server job run for longer than normal, and I could really have done …

sql-server sql-server-2005 timeout scheduling sql-server-agent
SQL Server Job - The system cannot find the file specified

I am running a SQL Server Agent job which zips up my database backups. The application I run is a …

sql-server sql-server-agent
The proper way to disable/enable SQLServer Agent Jobs

I have a number of SQLServer agent scheduled jobs, one of them performs a full database backup. I want to …

sql-server sql-server-agent
How SQL calculates NEXT_RUN_DATE for a job schedule?

I have to make a manual calculation of the next run date for a job, can you help me?

sql sql-server sql-server-agent
Create SQL Server job automatically

I am writing SQL Server deployment scripts which create SQL Server job automatically on a specific SQL Server server/instance. …

sql sql-server sql-server-2008 sql-server-agent
SQL Agent Job - Connection may not be configured correctly or you may not have the right permissions on this connection?

I'm getting this error when running an SSIS package through SQL Agent Failed to acquire connection "ORACLE ADO.NET". Connection …

sql-server oracle ssis connection sql-server-agent
SQL Server: should I use an "Agent Job" or a "Maintenance Plan" to delete old data?

I'm looking for a way to periodically (e.g. weekly) run some SQL statements in a database to delete old …

sql-server sql-server-2005 sql-server-agent maintenance-plan
unable to kill SQL server job, status stays killed/rollback

I am unable to kill some SQL Server agent jobs. The task state continues to be running and the command …

sql-server-2008 sql-server-agent
SQL Server add job agent T-SQL script issue

I am using SQL Server 2008 Enterprise. I have created a very simple test SQL Server Agent job which just print …

sql sql-server tsql sql-server-2008 sql-server-agent