Advertisement

04.23.2008 at 02:27PM PDT, ID: 23348442 | Points: 250
[x]
Attachment Details

SQL job schedule to run every 30 seconds

Asked by JMILANPI in MS SQL Server

Tags: SQL

I whant to schedule this Job to run every 30 seconds but SQL enterprise manager only allows me to run it every 1 minute.

I've heard you can put a delay command on the script but I'm new to SQL and have no clue where to put it or the sintaxis. Attached are screen captures of how it is configured.

Thanks !Start Free Trial
Attachments:
 
captures.JPG (114 KB) (File Type Details) 
Screen Captures of current job
Screen Captures of current job
 
 
Keywords: SQL job schedule to run every 30 se…
Title
1 TASK SCHEDULING
2 ASP Scheduler
3 schedule insert process
4 Scheduling events in Access- how to…
5 dbms_job schedule
6 How to schedule a job script using co…
 
Loading Advertisement...
 
[+][-]04.23.2008 at 02:29PM PDT, ID: 21425616

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.23.2008 at 02:34PM PDT, ID: 21425655

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.23.2008 at 02:45PM PDT, ID: 21425745

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.23.2008 at 02:51PM PDT, ID: 21425809

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.23.2008 at 03:14PM PDT, ID: 21425993

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.23.2008 at 07:56PM PDT, ID: 21427454

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.30.2008 at 02:42PM PDT, ID: 21681618

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.30.2008 at 02:47PM PDT, ID: 21681656

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628