Re: How do you update the SQL Server Agent's SysAdmin Password

http://sqldev.net/download/sqlagent/sp_sqlagent_set_connection.sql

--
HTH

Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

"jwbutler" <u16619@uwe> wrote in message news:58bdc8356dee5@xxxxxx
>I am trying to update the SQL Server Agent property SysAdmin Password. I
>am
> using sp_set_sqlagent_properties and all the other properties except
> password
> is being updated properly. This is a sample of the code I am using. Can
> any
> one help me get on the right track.
>
> DECLARE @Password as VARBINARY(512)
> SELECT @Password=CONVERT(VARBINARY(512),CAST('NEWPASSWORD' AS CHAR))
> exec sp_set_sqlagent_properties
> @auto_start=1,
> @sqlserver_restart=1,
> @jobhistory_max_rows=1000,
> @jobhistory_max_rows_per_job=100,
> @errorlog_file=NULL,
> @errorlogging_level=3,
> @error_recipient=NULL,
> @monitor_autostart=1,
> @local_host_server=NULL,
> @job_shutdown_timeout=15,
> @cmdexec_account=NULL,
> @regular_connections=1,
> @host_login_name='sa',
> @host_login_password=@Password,
> @login_timeout=30,
> @idle_cpu_percent=10,
> @idle_cpu_duration=600,
> @oem_errorlog=0,
> @sysadmin_only=1,
> @email_profile=NULL,
> @email_save_in_sent_folder=NULL,
> @cpu_poller_enabled=1


.

Relevant Pages

  • Re: How can I use MDX functions in SQL Query Analyzer (Client Tool)
    ... Jasper Smith (SQL Server MVP) ... community for SQL Server professionals - ... > somethingI need to enable, install, configure, tweek, activate, ...
    (microsoft.public.sqlserver.clients)
  • Re: Another 17055 error problem
    ... Jasper Smith (SQL Server MVP) ... >>That just looks like you have Auditing set to either ... >>community for SQL Server professionals - ...
    (microsoft.public.sqlserver.security)
  • Re: JOBS
    ... >Jasper Smith (SQL Server MVP) ... >community for SQL Server professionals - ... >>Give the user in question permission to exec these procs. ...
    (microsoft.public.sqlserver.security)
  • Re: using certain port for sql server 2000
    ... > community of SQL Server professionals. ... not to be overly picky, but you should fix your signature. ...
    (microsoft.public.sqlserver.server)
  • Re: identity seed
    ... > Wayne Snyder, MCDBA, SQL Server MVP ... > I support the Professional Association of SQL Server and it's ... > community of SQL Server professionals. ...
    (microsoft.public.sqlserver.server)