|
Home > Archive > MS SQL Server New Users > April 2005 > sql job for all databases
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
sql job for all databases
|
|
| Ekta Agarwal 2005-04-09, 8:25 pm |
| Dear sir/madam,
Is there any way to run one sql server job for all the databases.
regards,
ekta
| |
| Tom Moreau 2005-04-09, 8:25 pm |
| Undocumented:
exec sp_MSforeachDB '?.dbo.sp_helpfiles'
This just runs sp_helpfiles against all DB's. You would have to create your
own system stored proc and save it in master with an sp_ prefix.
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Ekta Agarwal" < ekta_egarwal@optusne
t.com.au> wrote in message
news:OJrsTwQPFHA.2680@TK2MSFTNGP09.phx.gbl...
Dear sir/madam,
Is there any way to run one sql server job for all the databases.
regards,
ekta
|
|
|
|
|