I have a schedule that does something daily, every two hours in a time interval. I want to set an end date for this schedule, but I'm wondering if it is inclusive or exclusive. In other words, if I...

Possible Duplicate: Executing SQL Server Agent Job from a stored procedure and returning job result Is there a way to determine when a sql agent job as finished once it has been start...

How can I drop sql server agent jobs, if (and only if) it exists? This is a well functioning script for stored procedures. How can I do the same to sql server agent jobs? if exists (select * from d...

SQL Server Jobs / Schedules - US vs. UK Daylight Savings Adjustment We have a UK based server which needs to run a SQL Agent Job at 16:30 (US Central time – this may seem strange but it because of...

I have a number of SQLServer agent scheduled jobs, one of them performs a full database backup. I want to disable some other jobs when backup begins and re-enable them once backup is done. What is ...

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

I prefer to keep our SSIS packages in a solution on the server, not in sql. By default, sensitive data is encrypted with a user key. Since the sql server agent uses a service account to run jobs, w...

I have a SSIS package running at 8 PM in the evening for the Year 2011. I would like to run the same package at 8:30 PM for the Year 2010. I made a SSIS Package configuration file and accept the ...

I would like to know what happens if an agent job (with recurring interval) in MS SQL server runs long enough so that it overlaps recurring execution. According to my tests, paralleled execution do...

None of the SQL Jobs on my server are running. I've looked into this and got the message: SQLServerAgent is not currently running so it cannot be notified of this action How can I get SQL ...

I am trying to add my email address to notifications for SQL Server Agent Job when it fails.. So I go SQL Server agent, open up the jobs, right click on the job and select properties and then noti...

I have some scheduled jobs in my SQL Agent: Job1, executing every 2 minutes Job2, executing every 10 minutes Job3, executing every 15 minutes As you can see, multiple jobs can run simultaneousl...

I came across these two services separately running in Services.msc - SQL Server (SQLEXPRESS) - started+Automatic SQL Server Agent (SQLEXPRESS) - Disabled Can you please guide why do we need ...

I have just had a scheduled SQL Server job run for longer than normal, and I could really have done with having set a timeout to stop it after a certain length of time. I might be being a bit blin...

I'm looking for a way to periodically (e.g. weekly) run some SQL statements in a database to delete old data. As far as I can see, there are (at least) two ways to do this: using a "Maintenance P...

I have scheduled sql agent task which runs an SSIS package. I want to be able to run the SSIS package from .net. Is there a way to either run the SSIS package directly or at least run the SQL agent...

If I know the database server name, instance name and the SQL Server job name, how to delete a SQL Server job by its name in a simple way? I am writing scripts which will be called by sqlcmd to del...

I am using SQL Server 2008 and I need to run a SQL Job from SQL Server Agent. I am new to SQL Server Job and I want to execute a stored procedure regularly from a SQL Server Job. But I did not find...

Sql server 2005 service pack 2 version: 9.00.3042.00 All maintenance plans fail with the same error. The details of the error are:- Execute Maintenance Plan Execute maintenance plan. test7 (...

If you schedule a SQL Server job to run every X number of minutes, and it does not finish the previous call before the # of minutes is up, will it skip the run since it is already running, or will ...