Showing posts with label proc. Show all posts
Showing posts with label proc. Show all posts

Wednesday, March 21, 2012

Listing all scheduled tasks on a server

I am trying to use

sp_help_jobstep

to detail the scheduled tasks on my server.

However I get an error saying the stored proc does not exist. Is it not installed by default or is it possibler it was deleted somehow?

Is there another way I can extract all my scheduled tasks so that I can produce a SQL script to automate their re-creation if they get deleted?

I am using SQL 7 and got this SP from bol.

ThanksOriginally posted by FunkyD
I am trying to use

sp_help_jobstep

to detail the scheduled tasks on my server.

However I get an error saying the stored proc does not exist. Is it not installed by default or is it possibler it was deleted somehow?

Is there another way I can extract all my scheduled tasks so that I can produce a SQL script to automate their re-creation if they get deleted?

I am using SQL 7 and got this SP from bol.

Thanks

Fixed it - forgot that you have to run against MSDB...lol
Posted by diverselzxr at 6:57 AM 0 comments
Labels: , , , , , , , , , , , , , , ,

Liste Tables

bonjour,
Existe t il une stored proc qui permette de récupérer la liste des tables
d'une base de donnée Sql 2K ?
Et si oui peut on ensuite récupérer la structure d'une table ; liste de
champs, d'index, de déclencheurs, contraints...etc
Merci
Christophe.There are many ways, pl. search the achives of this newsgroup. Here is an
easy one:
EXEC sp_tables
For keys, you can do:
EXEC sp_pkey 'tbl'
--
- Anith
( Please reply to newsgroups only )|||Sorry for this 'french' post, and Thanks for help !
Regards
Christophe
"meynet" <meynet@.csprogramme.com> a écrit dans le message de
news:bjq00r$670$1@.news-reader4.wanadoo.fr...
> bonjour,
> Existe t il une stored proc qui permette de récupérer la liste des tables
> d'une base de donnée Sql 2K ?
> Et si oui peut on ensuite récupérer la structure d'une table ; liste de
> champs, d'index, de déclencheurs, contraints...etc
> Merci
> Christophe.
>|||merci beaucoup, Vishal !
--
- Anith
( Please reply to newsgroups only )|||This is a multi-part message in MIME format.
--=_NextPart_000_03B7_01C37881.C6A60830
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
You should have left this one to Aaron then ;-)
-- Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message =news:uI4R99GeDHA.2236@.TK2MSFTNGP12.phx.gbl...
My French is weak but I think you need sp_help.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"meynet" <meynet@.csprogramme.com> wrote in message =news:bjq00r$670$1@.news-reader4.wanadoo.fr...
bonjour,
Existe t il une stored proc qui permette de r=E9cup=E9rer la liste des =tables
d'une base de donn=E9e Sql 2K ?
Et si oui peut on ensuite r=E9cup=E9rer la structure d'une table ; =liste de
champs, d'index, de d=E9clencheurs, contraints...etc
Merci
Christophe.
--=_NextPart_000_03B7_01C37881.C6A60830
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.2800.1226" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#c0c0c0>
<DIV><FONT face=3DArial size=3D2>You should have left this one to Aaron =then ;-)</FONT></DIV>
<DIV><BR>-- <BR>Jacco Schalkwijk MCDBA, MCSD, MCSE<BR>Database Administrator<BR>Eurostop Ltd.</DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Tom Moreau" <<A =href=3D"mailto:tom@.dont.spam.me.cips.ca">tom@.dont.spam.me.cips.ca</A>>= wrote in message <A =href=3D"news:uI4R99GeDHA.2236@.TK2MSFTNGP12.phx.gbl">news:uI4R99GeDHA.2236=@.TK2MSFTNGP12.phx.gbl</A>...</DIV>
<DIV><FONT face=3DTahoma size=3D2>My French is weak but I think you =need sp_help.</FONT></DIV>
<DIV><BR>-- <BR>Tom</DIV>
<DIV> </DIV>
=<DIV>---<BR>T=homas A. Moreau, BSc, PhD, MCSE, MCDBA<BR>SQL Server MVP<BR>Columnist, SQL =Server Professional<BR>Toronto, ON Canada<BR><A =href=3D"www.pinnaclepublishing.com=">http://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=
/sql</A></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>"meynet" <<A href=3D"mailto:meynet@.csprogramme.com">meynet@.csprogramme.com</A>> =wrote in message <A =href=3D"news:bjq00r$670$1@.news-reader4.wanadoo.fr">news:bjq00r$670$1@.news=-reader4.wanadoo.fr</A>...</DIV>bonjour,<BR><BR>Existe t il une stored proc qui permette de r=E9cup=E9rer la liste des =tables<BR>d'une base de donn=E9e Sql 2K ?<BR>Et si oui peut on ensuite r=E9cup=E9rer =la structure d'une table ; liste de<BR>champs, d'index, de d=E9clencheurs, =contraints...etc<BR><BR>Merci<BR>Christophe.<BR><BR></BLOCKQUOTE></BODY><=/HTML>
--=_NextPart_000_03B7_01C37881.C6A60830--|||This is a multi-part message in MIME format.
--=_NextPart_000_02A5_01C37857.EFA1EBC0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Y'know, just 'cuz we're Canadian, does mean we speak French, eh? ;-)
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> wrote in message =news:OTFK4jHeDHA.3024@.tk2msftngp13.phx.gbl...
You should have left this one to Aaron then ;-)
-- Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message =news:uI4R99GeDHA.2236@.TK2MSFTNGP12.phx.gbl...
My French is weak but I think you need sp_help.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"meynet" <meynet@.csprogramme.com> wrote in message =news:bjq00r$670$1@.news-reader4.wanadoo.fr...
bonjour,
Existe t il une stored proc qui permette de r=E9cup=E9rer la liste des =tables
d'une base de donn=E9e Sql 2K ?
Et si oui peut on ensuite r=E9cup=E9rer la structure d'une table ; =liste de
champs, d'index, de d=E9clencheurs, contraints...etc
Merci
Christophe.
--=_NextPart_000_02A5_01C37857.EFA1EBC0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.2800.1226" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#c0c0c0>
<DIV><FONT face=3DTahoma size=3D2>Y'know, just 'cuz we're Canadian, does =mean we speak French, eh? ;-)</FONT></DIV>
<DIV><BR>-- <BR>Tom</DIV>
<DIV> </DIV>
<DIV>---<BR>T=homas A. Moreau, BSc, PhD, MCSE, MCDBA<BR>SQL Server MVP<BR>Columnist, SQL =Server Professional<BR>Toronto, ON Canada<BR><A href=3D"www.pinnaclepublishing.com=">http://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=
/sql</A></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>"Jacco Schalkwijk" <<A href=3D"mailto:NOSPAMjaccos@.eurostop.co.uk">NOSPAMjaccos@.eurostop.co.uk</=A>> wrote in message <A href=3D"news:OTFK4jHeDHA.3024@.tk2msftngp13.phx.gbl">news:OTFK4jHeDHA.3024=@.tk2msftngp13.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>You should have left this one to Aaron =then ;-)</FONT></DIV>
<DIV><BR>-- <BR>Jacco Schalkwijk MCDBA, MCSD, MCSE<BR>Database Administrator<BR>Eurostop Ltd.</DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Tom Moreau" <<A =href=3D"mailto:tom@.dont.spam.me.cips.ca">tom@.dont.spam.me.cips.ca</A>>= wrote in message <A =href=3D"news:uI4R99GeDHA.2236@.TK2MSFTNGP12.phx.gbl">news:uI4R99GeDHA.2236=@.TK2MSFTNGP12.phx.gbl</A>...</DIV>
<DIV><FONT face=3DTahoma size=3D2>My French is weak but I think you =need sp_help.</FONT></DIV>
<DIV><BR>-- <BR>Tom</DIV>
<DIV> </DIV>
=<DIV>---<BR>T=homas A. Moreau, BSc, PhD, MCSE, MCDBA<BR>SQL Server MVP<BR>Columnist, SQL =Server Professional<BR>Toronto, ON Canada<BR><A =href=3D"www.pinnaclepublishing.com=">http://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=
/sql</A></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>"meynet" <<A href=3D"mailto:meynet@.csprogramme.com">meynet@.csprogramme.com</A>> =wrote in message <A =href=3D"news:bjq00r$670$1@.news-reader4.wanadoo.fr">news:bjq00r$670$1@.news=-reader4.wanadoo.fr</A>...</DIV>bonjour,<BR><BR>Existe t il une stored proc qui permette de r=E9cup=E9rer la liste des =tables<BR>d'une base de donn=E9e Sql 2K ?<BR>Et si oui peut on ensuite r=E9cup=E9rer =la structure d'une table ; liste de<BR>champs, d'index, de d=E9clencheurs, =contraints...etc<BR><BR>Merci<BR>Christophe.<BR><BR></BLOCKQUOTE></BODY><=/HTML>
--=_NextPart_000_02A5_01C37857.EFA1EBC0--|||de rien, je vous en prie
uhh, i've to take help this :-)
http://www.canuckabroad.com/language/french.shtml
Cheers,
-Vishal
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:uhKjgiHeDHA.3024@.tk2msftngp13.phx.gbl...
> merci beaucoup, Vishal !
> --
> - Anith
> ( Please reply to newsgroups only )
>|||This is a multi-part message in MIME format.
--=_NextPart_000_02FD_01C37860.F8CD8D40
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
He's from North Bay, Ontario.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> wrote in message =news:#oIPWpHeDHA.2268@.TK2MSFTNGP10.phx.gbl...
I thought Aaron is a French Canadian? (or should that be Quebecois?)
-- Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message =news:e7GBqlHeDHA.2248@.TK2MSFTNGP09.phx.gbl...
Y'know, just 'cuz we're Canadian, does mean we speak French, eh? ;-)
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> wrote in message =news:OTFK4jHeDHA.3024@.tk2msftngp13.phx.gbl...
You should have left this one to Aaron then ;-)
-- Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message =news:uI4R99GeDHA.2236@.TK2MSFTNGP12.phx.gbl...
My French is weak but I think you need sp_help.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"meynet" <meynet@.csprogramme.com> wrote in message =news:bjq00r$670$1@.news-reader4.wanadoo.fr...
bonjour,
Existe t il une stored proc qui permette de r=E9cup=E9rer la liste =des tables
d'une base de donn=E9e Sql 2K ?
Et si oui peut on ensuite r=E9cup=E9rer la structure d'une table ; =liste de
champs, d'index, de d=E9clencheurs, contraints...etc
Merci
Christophe.
--=_NextPart_000_02FD_01C37860.F8CD8D40
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

He's from North Bay, =Ontario.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Jacco Schalkwijk" wrote in message news:#oIPWpHeDHA.2268=@.TK2MSFTNGP10.phx.gbl...
I thought Aaron is a French Canadian? =(or should that be Quebecois?)
-- Jacco Schalkwijk MCDBA, MCSD, MCSEDatabase AdministratorEurostop Ltd.
"Tom Moreau" = wrote in message news:e7GBqlHeDHA.2248=@.TK2MSFTNGP09.phx.gbl...
Y'know, just 'cuz we're Canadian, =does mean we speak French, eh? ;-)
-- Tom

=---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql


"Jacco Schalkwijk" wrote in message news:OTFK4jHeDHA.3024=@.tk2msftngp13.phx.gbl...
You should have left this one to =Aaron then ;-)
-- Jacco Schalkwijk MCDBA, MCSD, MCSEDatabase AdministratorEurostop Ltd.


"Tom Moreau" = wrote in message news:uI4R99GeDHA.2236=@.TK2MSFTNGP12.phx.gbl...
My French is weak but I think you =need sp_help.
-- Tom

=---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql


"meynet" =wrote in message news:bjq00r$670$1@.news=-reader4.wanadoo.fr...bonjour,Existe t il une stored proc qui permette de r=E9cup=E9rer la liste des =tablesd'une base de donn=E9e Sql 2K ?Et si oui peut on ensuite r=E9cup=E9rer =la structure d'une table ; liste dechamps, d'index, de d=E9clencheurs, =contraints...etcMerciChristophe.

--=_NextPart_000_02FD_01C37860.F8CD8D40--sql
Posted by diverselzxr at 6:49 AM 0 comments
Labels: , , , , , , , , , , , , , , , , , , ,

Friday, March 9, 2012

List of SP names and parameters

I need to come up with a list of all Stored Procedures in
a given database and the associated parameters passed,
something like this:
Proc Name parmater
proc1 a,b
proc2 a
proc3 -
I would really appreciate if somesone can shed some light
on how to do this.
Thankswww.aspfaq.com/2463
"Adel Asaad" <Adel.Asaad@.Trade-ranger.com> wrote in message
news:52f201c34195$4880d0c0$a401280a@.phx.gbl...
> I need to come up with a list of all Stored Procedures in
> a given database and the associated parameters passed,
> something like this:
> Proc Name parmater
> proc1 a,b
> proc2 a
> proc3 -
> I would really appreciate if somesone can shed some light
> on how to do this.
> Thanks|||Thank you very much. That did it - I really appreciate
the quick response.
Adel
>--Original Message--
>www.aspfaq.com/2463
>
>
>"Adel Asaad" <Adel.Asaad@.Trade-ranger.com> wrote in
message
>news:52f201c34195$4880d0c0$a401280a@.phx.gbl...
>> I need to come up with a list of all Stored Procedures
in
>> a given database and the associated parameters passed,
>> something like this:
>> Proc Name parmater
>> proc1 a,b
>> proc2 a
>> proc3 -
>> I would really appreciate if somesone can shed some
light
>> on how to do this.
>> Thanks
>
>.
>
Posted by diverselzxr at 8:29 AM 0 comments
Labels: , , , , , , , , , , ,
Subscribe to: Posts (Atom)