how to change password

We have change administrator password. How can i change the sql server job password, so that the maintain plan work fine as before. Thanks.Modify the login used by the SQL Server Agent service.|||Thank you very much! So i just right click the sql server agent then change password there.|||Right-click the service, open up properties, and go to the Logon tab. That is the most likely culprit.|||i am a little bit confuse. What i did is go to sql server enterprise manager, the expand the management, then right click the sql server agent to open properties. then change the password there. But i am sure what service you got, where can i find it? Did i did something wrong. Can you give me more detail about changing the password? Thank you very much!

How to catchup job schedule? Scheduled jobs not running.

Hi,
I try not to schedule jobs during sw/hw maintenance windows, but sometimes
it happens - even more so now with active windows update running. It just
shuts down without regard to what's running.
Unfortunately, when the sql server comes back up, it doesn't run jobs that
are past due. I can't seem to find any setting that would 'catch-up' the
jobs. Would you share your thoughts on how to deal with this situation.
thanks
Doug
I don't think there is a "built-in" function for this type of situation.
However, you can create your own stored procedure that queries
msdb..sysjobhistory and look for run_status = 0, then use sp_start_job to
start those jobs that failed. And then you can set up a scheduled job to run
this SP during every restart.
"Doug Little" wrote:

> Hi,
> I try not to schedule jobs during sw/hw maintenance windows, but sometimes
> it happens - even more so now with active windows update running. It just
> shuts down without regard to what's running.
> Unfortunately, when the sql server comes back up, it doesn't run jobs that
> are past due. I can't seem to find any setting that would 'catch-up' the
> jobs. Would you share your thoughts on how to deal with this situation.
> thanks
> --
> Doug

How to catchup job schedule? Scheduled jobs not running.

Hi,
I try not to schedule jobs during sw/hw maintenance windows, but sometimes
it happens - even more so now with active windows update running. It just
shuts down without regard to what's running.
Unfortunately, when the sql server comes back up, it doesn't run jobs that
are past due. I can't seem to find any setting that would 'catch-up' the
jobs. Would you share your thoughts on how to deal with this situation.
thanks
DougI don't think there is a "built-in" function for this type of situation.
However, you can create your own stored procedure that queries
msdb..sysjobhistory and look for run_status = 0, then use sp_start_job to
start those jobs that failed. And then you can set up a scheduled job to ru
n
this SP during every restart.
"Doug Little" wrote:

> Hi,
> I try not to schedule jobs during sw/hw maintenance windows, but sometimes
> it happens - even more so now with active windows update running. It just
> shuts down without regard to what's running.
> Unfortunately, when the sql server comes back up, it doesn't run jobs that
> are past due. I can't seem to find any setting that would 'catch-up' the
> jobs. Would you share your thoughts on how to deal with this situation.
> thanks
> --
> Doug

How to catchup job schedule? Scheduled jobs not running.

Hi,
I try not to schedule jobs during sw/hw maintenance windows, but sometimes
it happens - even more so now with active windows update running. It just
shuts down without regard to what's running.
Unfortunately, when the sql server comes back up, it doesn't run jobs that
are past due. I can't seem to find any setting that would 'catch-up' the
jobs. Would you share your thoughts on how to deal with this situation.
thanks
--
DougI don't think there is a "built-in" function for this type of situation.
However, you can create your own stored procedure that queries
msdb..sysjobhistory and look for run_status = 0, then use sp_start_job to
start those jobs that failed. And then you can set up a scheduled job to run
this SP during every restart.
"Doug Little" wrote:
> Hi,
> I try not to schedule jobs during sw/hw maintenance windows, but sometimes
> it happens - even more so now with active windows update running. It just
> shuts down without regard to what's running.
> Unfortunately, when the sql server comes back up, it doesn't run jobs that
> are past due. I can't seem to find any setting that would 'catch-up' the
> jobs. Would you share your thoughts on how to deal with this situation.
> thanks
> --
> Doug

How to call job step X from job step Y:

I have a SQL Server Agent job with multiple steps. I want
to be able to goto a specific job steps by choice from a
step within the job. How do I make a acll to another step
from a job step.
For example, based on data returned in step 5, I could go
to step 1, 2, 3 or 4. 'OnSuccess', OnFailure' flow is not
good enough in the given scenario. I don't want to use
sp_start_job to start the job at a specific step because
the job is already running and I just want to set the
control-of-flow to a different step.
Thanks
Abdul Gill
DBA/Royal Caribbean Cruise LimitedHi Abdul
Job Step control does limit your options for controlling process flow, so
how about using a DTS package? DTS gives you easy control over process flow
& can be scheduled into a SQL Agent Job as well. The tools for implementing
complex processes are far more advanced in DTS, there's even a GUI to
support visualisation of the process logic..
Regards,
Greg Linwood
SQL Server MVP
"Abdul M. Gill" <agill@.rccl.com> wrote in message
news:1474e01c41381$3b8f6a20$a101280a@.phx
.gbl...
> I have a SQL Server Agent job with multiple steps. I want
> to be able to goto a specific job steps by choice from a
> step within the job. How do I make a acll to another step
> from a job step.
> For example, based on data returned in step 5, I could go
> to step 1, 2, 3 or 4. 'OnSuccess', OnFailure' flow is not
> good enough in the given scenario. I don't want to use
> sp_start_job to start the job at a specific step because
> the job is already running and I just want to set the
> control-of-flow to a different step.
> Thanks
> Abdul Gill
> DBA/Royal Caribbean Cruise Limited

How to call a stored procedure in a scheduled job

Hi All,

I have a stored procedure.

I need to create a scheduled job using that stored procedure.

I went to Enterprise Manager -->Management--> Jobs-->New Job
Properties

In the step tab, I can select db and put the codes.
Instead of writing the code there, I want to call the stored procedure
in the command box.

How can I do that?

System: MS SQL Server 2000

I would highly appreciate your help.

Thanks a million in advance.

Best regards,

mamunIn the Type Dropdown, select T-SQL & call your stored procedure like:

EXEC usp...

--
- Anith
( Please reply to newsgroups only )