|
Hi,
I need to get all the Packages that are run either by using Job or without using the Jobs, I need the statuses of those Packages, whether they are failed or success.
This is because I have a console application that's executing all the Packages one after the other, but if the Packages failed internally we are not informed of that, so I want to go ahead and check status of the Package after execution using query and find out what has happened.
Any help would be greatly helpful. Thanks in advance. I want to get all the packages that are executed either by Job or without using the Job on a database.
Thanks,
Abdul Aleem
"There is already enough hatred in the world lets spread love, compassion and affection."
|
|
|
|
|
create or replace procedure updateStudentResult(id int,
m1 in int,
m2 in int,
m3 in int,
tot out int,
avg out float,
grd out char)
as
begin
select marks1,marks2,marks3 into m1,m2,m3 from students where sid=id;
tot:=m1+m2+m3;
avg:=(m1+m2+m3)/3;
if avg >= 85 then
grd:='A';
elsif (avg >= 65) then
grd:='B';
elsif (avg >= 50) then
grd:='C';
else
grd:='D';
end if;
UPDATE students SET
total=tot,
average=avg,
grade=grd
where sid=id;
end;
/
|
|
|
|
|
Do you have a question or are you just trying to showcase your code?
|
|
|
|
|
|
Fix the compilation error that it tells you about.
There are two kinds of people in the world: those who can extrapolate from incomplete data.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
It looks like you downvoted my post and that's fine; however, the reason I said to fix the compilation error is because you haven't even shared with us what the exact error is, so how can we possibly help you fix it?
There are two kinds of people in the world: those who can extrapolate from incomplete data.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
u can tell me to mention,not suppose to give slogans
|
|
|
|
|
3 people tried to nudge you in the right direction and you downvoted all of them. You still haven't given us the exact error.
We're all volunteers and we're being very polite in trying to help you. If you called up tech support and said "I'm getting an error on my computer." of course the first question will be, "What is the error?"
Same thing in an online forum. If you ask us how to fix an error, then tell us the error. There are 42,654,344 possible errors so we can't possibly guess which one you are getting. Plus, the error probably tells you exactly what is wrong and if you would just read it, you probably wouldn't even need our help.
There are two kinds of people in the world: those who can extrapolate from incomplete data.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
ohk cool bro
am new here ,In a hurry i forget it happens sometime
sorry
next tym i will keep this in mind
thanks for going through my code
|
|
|
|
|
issue is solved now thankss i will keep ur suggestions in my mind, but you should tell in descent way
|
|
|
|
|
LOKENDRA YADAV wrote: issue is solved now
Good. Glad to hear it.
LOKENDRA YADAV wrote: , but you should tell in descent way
I think all 3 of us were very polite. Sorry if you felt different.
There are two kinds of people in the world: those who can extrapolate from incomplete data.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Hi,I want to make demo on SQL server,but I want to ask one question while making demo I have to mention only theory concept or code in them also???Can any one help???
|
|
|
|
|
|
You'll have to do some code unless you want to only demo features that don't require any code.
There are two kinds of people in the world: those who can extrapolate from incomplete data.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
SQL Server 2016 LocalDB installed, and instance 'FFw1a' is created and running:
C:\Program Files\Microsoft SQL Server\130\Tools\Binn>sqllocaldb i Ffw1a
Name: FFw1a
Version: 13.0.2151.0
Share name:
Owner: MinKyung\icey.dong
Auto Create: No
Status: Running
Start Time: 2017/3/3 16:48:38
Pipe name: np:\\.\pipe\LOCALDB#E10BE0E6\tsql\query
I want to create a local db file by below C# code:
private void CreateDatabase()
{
System.Data.SqlClient.SqlConnection tmpConn;
string sqlCreateDBQuery;
tmpConn = new SqlConnection();
tmpConn.ConnectionString = @"Data Source=(LocalDB)\FFw1a;AttachDbFilename='D:\y\2\TestDB_Data.mdf'; Integrated Security=True;Connect Timeout=30;Encrypt=False";
sqlCreateDBQuery = "CREATE DATABASE TestDB ON PRIMARY "+
@"(NAME = TestDB_Data, FILENAME = 'D:\y\2\TestDB_Data.mdf', SIZE = 2MB, FILEGROWTH = 10%) "+
@"LOG ON (NAME = TestDB_Log, FILENAME = 'D:\y\2\TestDB_Log.ldf', SIZE = 1MB, FILEGROWTH = 10%)";
SqlCommand myCommand = new SqlCommand(sqlCreateDBQuery, tmpConn);
try
{
tmpConn.Open();
myCommand.ExecuteNonQuery();
MessageBox.Show("Database has been created successfully!", "Create Database", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (System.Exception ex)
{
MessageBox.Show(ex.ToString(), "Create Database", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
tmpConn.Close();
}
return;
}
But it cause exception on 'tmpConn.Open()', and the message is:
An attempt to attach an auto-named database for file D:\y\2\TestDB_Data.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
How can I change the connection string and sqlCreateDBQuery to create a database file successfully?
|
|
|
|
|
Change the file names in the CREATE DATABASE statement so they use different file names to the one in your original connection string. You use AttachDbFilename='D:\y\2\TestDB_Data.mdf' in the connection string, then try to create a database file of the same name.
=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================
|
|
|
|
|
Tried, but also failed.
The exception is caused on 'tmpConn.Open()', not create databse anymore.
|
|
|
|
|
tmpConn.ConnectionString = @"Data Source=(LocalDB)\FFw1a;AttachDbFilename='D:\y\2\TestDB_Data.mdf'; Integrated Security=True;Connect Timeout=30;Encrypt=False";
remove this
|
|
|
|
|
I have no idea how to do that.
|
|
|
|
|
Which database engine?
Are the databases on the same server?
|
|
|
|
|
Hi All,
We have like 150 SQL Server Packages with around 20 jobs that run everyday in our Organization, for some reason some jobs are not running. What I need to do find out which Jobs ran successfully, which Jobs failed , which Jobs haven't started at all, if Job is failed then find out which steps are failed and inform to the corresponding persons with Email, for Email I wrote an Application, but I am trying to find out the ways to check the status of the Jobs, any suggestion, code snippet or even link helps me a lot.
Its little urgent, please help me - thanks in advance.
Thanks,
Abdul Aleem
"There is already enough hatred in the world lets spread love, compassion and affection."
|
|
|
|
|
|
I can't tell if mysql clustering could be a solution(I am thinking about galera or xtradb clustering). But my biggest problem is about the unstable internet connection.
Actually it is planned as multi-tenant setup with a single online mysql server and the tenant is separated by schema, and a tenant can also have their own local database on their location.
But I want to solve this problem first.
For example I have a tenant, but this tenant has a multiple collocation, and want to sync the data on every location and also on the online server.
They can read/write on the first, second, etc collocation server using a desktop app(respective to their location) and they can also read/write on the online server using a mobile app.
Now my problem is how could I sync them, when internet is available? So data written and updated on the first location will propagate to other server, on the online server on the second server and so on, and vice-versa.
P.S. Data deletion will be soft-delete.
Thanks.
|
|
|
|
|
|
Thanks. A very nice concept, I definitely want to try that.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
