I have a sql server automatic job set up containing 2 steps.
First step is an Operating System Command (CmdExec) type job which
runs a .bat file which copies across a backup file to this machine.
The second step is a Transact -SQL Script (TSQL) type job which runs
the RESTORE DATABASE REPLACE command which restores the backup file
copied across in step 1.
Step 1's advanced option says: On Success Action: Goto Step [2]
Restore the database.
Step 2's advanced option says: On Success Action: Quit the job
reporting success.
On clicking ok I receive the error message:
"WARNING: The following job step(s) cannot be reached with current
flow logic: [1] Transfer the Backup File. Are you sure this is what
you want".
The job fails to run.
Both steps do run successfully when set up as two separate jobs - not
like this which has the two steps in one job.
Anyone have any ideas as to what the flow logic problem is?
Thiko!
2  28328 
I would guess that you have somehow set Step 2 as the starting step in the
package. Look at the "properties " for the job, check the "steps" tabbed
dialog and verify that the "start step" in the dropdown list box in the
lower middle of this dialog is set to your step 1 task. Reset it, if
necessary.
Otherwise, you could throw the job away and start over, being careful to put
your step 1 in first and then your step 2 in second to help SQL server
understand what you're trying to do.
"Thiko" <bi*****@hotmai l.com> wrote in message
news:b8******** *************** **@posting.goog le.com... I have a sql server automatic job set up containing 2 steps.
First step is an Operating System Command (CmdExec) type job which
runs a .bat file which copies across a backup file to this machine.
The second step is a Transact -SQL Script (TSQL) type job which runs
the RESTORE DATABASE REPLACE command which restores the backup file
copied across in step 1.
Step 1's advanced option says: On Success Action: Goto Step [2]
Restore the database.
Step 2's advanced option says: On Success Action: Quit the job
reporting success.
On clicking ok I receive the error message:
"WARNING: The following job step(s) cannot be reached with current
flow logic: [1] Transfer the Backup File. Are you sure this is what
you want".
The job fails to run.
Both steps do run successfully when set up as two separate jobs - not
like this which has the two steps in one job.
Anyone have any ideas as to what the flow logic problem is?
Thiko!
Yes, you were right. Thank you very much :) It's all sorted now. I
had the start steps the wrong way round.
"DHatheway" <dl********@mmm .com.nospam> wrote in message news:<bj******* ***@tuvok3.mmm. com>... I would guess that you have somehow set Step 2 as the starting step in the
package. Look at the "properties " for the job, check the "steps" tabbed
dialog and verify that the "start step" in the dropdown list box in the
lower middle of this dialog is set to your step 1 task. Reset it, if
necessary.
Otherwise, you could throw the job away and start over, being careful to put
your step 1 in first and then your step 2 in second to help SQL server
understand what you're trying to do.
"Thiko" <bi*****@hotmai l.com> wrote in message
news:b8******** *************** **@posting.goog le.com... I have a sql server automatic job set up containing 2 steps.
First step is an Operating System Command (CmdExec) type job which
runs a .bat file which copies across a backup file to this machine.
The second step is a Transact -SQL Script (TSQL) type job which runs
the RESTORE DATABASE REPLACE command which restores the backup file
copied across in step 1.
Step 1's advanced option says: On Success Action: Goto Step [2]
Restore the database.
Step 2's advanced option says: On Success Action: Quit the job
reporting success.
On clicking ok I receive the error message:
"WARNING: The following job step(s) cannot be reached with current
flow logic: [1] Transfer the Backup File. Are you sure this is what
you want".
The job fails to run.
Both steps do run successfully when set up as two separate jobs - not
like this which has the two steps in one job.
Anyone have any ideas as to what the flow logic problem is?
Thiko! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Mary Lei |
last post by:
After instaling db2 8.2.2 on a solaris box
I ran a script that drops a database and
then creates it.
This scripts runs fine under db2 8.2.1
on linux.
With 8.2.2 I got a mysterious error about
a 'reserved1' parameter when creating a new database which I
dont have it coded anywhere.
This error only occurs when I run the
|
by: MLH |
last post by:
< < < VERY LOW PRIORITY POST > > >
When I'm creating a query in the QBE grid whose SQL looks like this...
INSERT INTO tblOwners (OwnerFName, OwnerLName, OwnerAddr, OwnerCity,
OwnerState, OwnerZip, OwnerPhone, OwnerSSN, UserID)
SELECT !! AS OwnerFName,
!! AS OwnerLName,
!! AS OwnerAddr,
!! AS OwnerCity,
!! AS OwnerState,
|
by: CroDude |
last post by:
Heya all!
I have a weird problem when creating a texture brush in a Paint event.
When program gets to the line where I'm creating a new TextureBrush object,
it crashes with OutOfMemory exception.
Here's the code:
private void pnl_DrawSurface_Paint(object sender,
System.Windows.Forms.PaintEventArgs e)
|
by: Patrick Spence |
last post by:
(sorry 'bout the multipost)
VS.NET 2003 v 7.1.3088
..NET Framework v1.1.4322
XP Pro
IIS 5.0
When I try to create a ASP.NET application, I get the following error...
The Web server reported the following error when attempting to create or
|
by: foo |
last post by:
Hello,
I have a form that I developed in a small simple project. The form runs
fine by itself. When I try to create a new form that inherits from this
form, the machine goes off in the weeds for many minutes and throws off an
error 5 "Invalid procedure call or argument", and uses up all the machine
resources so Windows has to increase them in order to continue. It never
does finish the operation of creating the new form. I have to kill...
| | |
by: Eric Voigt |
last post by:
are there special settings applied to IIS5, when creating a webService in
VS.NET?
I wonder - because when I create a webService (let's call it webservice1)
using VStudio.NET on my remote W2K IIS5 it works fine and without any
problems.
When I don't use the VStudio.NET Wizard but only copy the .asmx and
bin/*.dll files to another web (on the _same_ server) it won't work! I
double-checked every setting in IIS and NTFS and can't found any...
|
by: Opa |
last post by:
When creating a new web service, I get the following error:
Visual Studio .net cannot create or open the application. Web site
'http://localhost/WDWS' not started.
The World Wide Web Publish service is started prior to attempting to create
a new web service with vs.net. After I get this error, the service stops.
Here are my steps:
|
by: ReidarT |
last post by:
The former post was wrong, the lines where concatenated so here it goes
again.
I am wrriting to a file (XML-format) and using
FileOpen(1, "C:\vb\WebBrowser\WebBrowserControl\TESTFILE.XML",
OpenMode.Output)
Write(1, "<?xml version=""1.0""?>")
....
|
by: Joe Penora |
last post by:
Hi All,
How to add the HTML script when creating new ASPX page. After it is done I
may need to add some Meta tags etc... but the html script is not there.
Is there an option in the ASP.NET that WHEN creating a new aspx page, then
it will generate that basic HTML scrip as well.
Regards,
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
