![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
![]() |
Wed, Jul 29 2009 1:56 AM | Permanent Link |
Steve Gill | I'm trying to call a stored procedure from a new job I created via EDBManager, but it says the procedure doesn't exist, even though it does.
BEGIN CALL DatabaseBackup; END What am I doing wrong? Regards, Steve |
Wed, Jul 29 2009 5:07 AM | Permanent Link |
Fernando Dias ![]() | Steve,
That's because in a Job, the default active database is the "Configuration" database and the procedure you are calling was created in another database. You may open and use a different database using "USE" : BEGIN USE "YourDatabaseName" ; CALL DatabaseBackup ; USE ; END You can find more about use here: http://www.elevatesoft.com/manual?action=mantopic&id=edb1sql&category=13&topic=234 -- Fernando Dias [Team Elevate] |
Wed, Jul 29 2009 6:41 PM | Permanent Link |
Steve Gill | "Fernando Dias" wrote:
> That's because in a Job, the default active database is the "Configuration" > database and the procedure you are calling was created in another database. > You may open and use a different database using "USE" : > BEGIN > USE "YourDatabaseName" ; > CALL DatabaseBackup ; > USE ; > END > You can find more about use here: > http://www.elevatesoft.com/manual?action=mantopic&id=edb1sql&category=13&topic=234 Excellent, thanks Fernando. I tried prepending the databasename to the stored procedure, eg. CALL MyDatabase.DatabaseBackup, but that didn't work. I didn't know about "USE". Thanks for your help. Regards, Steve |
This web page was last updated on Wednesday, August 14, 2024 at 03:12 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |