ASP.NET

How to pass parameters into sql jobs?

23-Mar-08 20:35

If you let your client know that you're passing the work on to me, so I can invoice for it, I'd be glad to do it. Or, you could buy a component that does the work you're incapable or. Or buy a book and read it.

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

ashish bhakhar23-Mar-08 19:19

ashish bhakhar

23-Mar-08 19:19

How to pass the parameters of @dbName, @LogicalName, @ToServer

to job dynamically using stored procedure?

Christian Graus23-Mar-08 20:36

23-Mar-08 20:36

This belongs in the SQL forum, where I'd advise you to look into how google works. Parameters are specified by adding them to the parameters collection, heaps of info on the web, or in your books.

ashish bhakhar23-Mar-08 20:44

ashish bhakhar

23-Mar-08 20:44

hello Christian Graus
i cant find reply of this question in sql forum,
that's why for fast reply i put it here.

Christian Graus23-Mar-08 21:19

23-Mar-08 21:19

And what did you find with google ? What code are you using to call your proc ?

ashish bhakhar23-Mar-08 23:22

ashish bhakhar

23-Mar-08 23:22

nothing find from google.
that's why i put my question here.
i have more expectations from codeproject than google.

This is my sql job:

USE [master]
GO
declare @file as varchar(500)
declare @dbName as varchar(50)
declare @LogicalName as varchar(50)
declare @ToServer as varchar(50)
exec('ALTER DATABASE ['+@dbName+'] SET SINGLE_USER WITH ROLLBACK IMMEDIATE')
exec('RESTORE DATABASE ['+@dbName+'] FROM DISK = N''F:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup\'+@file+''' WITH FILE = 1, MOVE N'''+@LogicalName+''' TO N''F:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data\'+@dbName+'.mdf'', MOVE N'''+@LogicalName+'_log'' TO N''F:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data\'+@dbName+'_log.ldf'', NOUNLOAD, REPLACE, STATS = 10')
GO

I want to pass above four parameters like @file,@dbName,@LogicalName,@ToServer from my stored procedure to above job.

so, what i have to do for this?

this is my stored procedure:

ALTER PROCEDURE runjob
AS
Declare @backupfile varchar(500),@databasename varchar(50),
@logicaldatabasename varchar(50), @toservername varchar(50)
set @backupfile = 'test1.bak';
set @databasename = 'test1';
set @logicaldatabasename = 'test1';
set @toservername = 'Live';
BEGIN
--exec sp_who2
EXEC msdb.dbo.sp_add_job
@job_name = 'k',
@file = @backupfile,
@dbName = @databasename,
@LogicalName = @logicaldatabasename,
@ToServer = @toservername
EXEC msdb.dbo.sp_start_job k
END

so, what i have to do for this? and i m receiving an error
@file is not a parameter for procedure sp_add_job.

saini arun24-Mar-08 5:39

saini arun

24-Mar-08 5:39

Specify all parameters like this...

ALTER PROCEDURE runjob

@file1 varchar(50). @directoryName varchar(50)

AS

<procedure body="">

“The woods are lovely, dark and deep. But I have promises to keep, and miles to go before I sleep.”

Christian Graus24-Mar-08 9:59

order by clause in crystal reports

24-Mar-08 9:59

Oh.... see, not only was this entirely a SQL question ( did you post it there ? ), but you were not asking what I thought you were asking. I kept asking you how you called the proc, b/c I thought you wanted to know how to pass the parameter into the proc. Really, you wanted to know how to write a stored proc in the first place. This is where posting code really helps, if you'd done that in the first place, I'd have made sense of your question and answered it ( the way you pass params into a proc depends on how you're calling it in .NET code, that's why I kept asking that and not giving a full answer ).

Pankaj Garg23-Mar-08 19:15

Pankaj Garg

23-Mar-08 19:15

i am manually creating the record no in the table , database - sql-server
when i see those records in the crystal reports , it is comming in arbitrary order.
Is there any way to arrange the records in an order.All i want is that , can i use the order by clause in crystal reports.

If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!

Re: order by clause in crystal reports

Pankaj Garg23-Mar-08 22:59

Pankaj Garg

23-Mar-08 22:59

Thank You to all of u...
Problem is solved. Smile | :)

How to avoid page refresh on click of F5

Prateek G23-Mar-08 18:54

Prateek G

23-Mar-08 18:54

I want to avoid to page to get refreshed on click of F5,Is it possible and how?

Thanks..

Re: How to avoid page refresh on click of F5

Christian Graus23-Mar-08 20:36

CollectionBase trouble...

23-Mar-08 20:36

Not possible. You are programming an engine to provide HTML to IE, you cannot stop IE from working.

Kasic Slobodan23-Mar-08 16:13

Kasic Slobodan

23-Mar-08 16:13

I've downloaded some sample project and I found that contains code of how to implement adding items from design mode (CollectionBase).

I've started to implement that into my test project I was working on and created a property like.

public MenuItemCollection MenuItems
{
        get { return items; }
}

When I go to design mode and add user control, in property grid, of that user control, I have MenuItems, but it doesn't open a dialog letting me to add the items. It acts like a string Confused | :confused:

.

To check whether I am crazy or not, I've added bool property to see will this work fine and display as a dropdown with true and false.

That did worked, so now I am puzzled. I've searched on the net with no luck.
I don't see any differences between that sample project and mine except that I use UserControl (partial class), but then again, why shouldn't properties work with partial classes as well (they worked with bool property) so now I am asking you for help.

Thanks.

Re: CollectionBase trouble...

N a v a n e e t h23-Mar-08 19:06

N a v a n e e t h

23-Mar-08 19:06

Kasic Slobodan wrote:
public MenuItemCollection MenuItems
{
get { return items; }
}

Looks like you are missing some attributes that has to be specified to add collection properties through property grid. I have an article which explains this. Have a look at here[^]

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: CollectionBase trouble...

Kasic Slobodan24-Mar-08 7:53

Kasic Slobodan

24-Mar-08 7:53

Your article helped.
Thank you.

Supporting Unicode in SQL DB

Mohammad A Gdeisat23-Mar-08 15:11

Mohammad A Gdeisat

23-Mar-08 15:11

Hi,

I am trying to save non-english text in my database, I tried using the ntext and nchar but none of them seems to be working..

Any ideas on how to do this

Thaaaaaaaanx

Mohammad

And ever has it been that love knows not its own depth until the hour of separation

Christian Graus23-Mar-08 15:17

23-Mar-08 15:17

I think when you create a DB, you set up what character set it uses, then I'd expect nvarchar and nchar to work just fine.

Mohammad A Gdeisat23-Mar-08 15:21

Mohammad A Gdeisat

23-Mar-08 15:21

Hi
My db is an sql database created in the server explorer in VS 2005, I really didn't notice any charset settings, and now when I select database properties I still don't see any settings for character set.

Any idea on how to modify these settings?

Thanks Smile | :)

And ever has it been that love knows not its own depth until the hour of separation

Christian Graus23-Mar-08 16:00

23-Mar-08 16:00

Mohammad A Gdeisat wrote:
My db is an sql database

Of course it is. All DBs are SQL databases. Do you mean SQL Server ?

When I right click on a DB in SQL Server management studio, there's a property called 'collation' which looks to me like the char set to use.