skip to main | skip to sidebar

Systems808

Systems engineering tips, tricks and advice.

"The only thing necessary for the triumph of evil is for good men to do nothing" - Edmund Burke

Friday, May 25, 2012

Non-sa access to SQL 2000 Jobs

Add users to role TargetServersRole in MSDB database for SQL 2000 SP3+.

Reference:
http://www.sql-server-performance.com/2006/sqlagent-scheduled-jobs/
Posted by Crispin at 6:19 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Jobs, SQL 2000, TargetServersRole
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Search This Blog

Labels

  • SQL 2005 (33)
  • Windows 2003 (33)
  • SQL 2008 (20)
  • VMware (19)
  • Netapp (16)
  • SQL 2000 (12)
  • Windows 2000 (10)
  • Netbackup (9)
  • SQL (9)
  • IIS (8)
  • Reporting Services (8)
  • Powershell (7)
  • SSRS (7)
  • User Rights (7)
  • Windows XP (6)
  • Cluster (5)
  • SSIS (5)
  • Windows (5)
  • Windows 7 (5)
  • A-SIS (4)
  • Active Directory (4)
  • RDP (4)
  • SSL (4)
  • function (4)
  • ESXi (3)
  • WSUS (3)
  • Win 2008 (3)
  • Win 2008 R2 (3)
  • Windows 2008 (3)
  • DCOM (2)
  • DTS (2)
  • ESXi 4.0 (2)
  • IIS7 (2)
  • Java (2)
  • Jobs (2)
  • Licensing (2)
  • Linked Server (2)
  • NIC (2)
  • Permissions (2)
  • SSMS (2)
  • Security group (2)
  • Win 7 (2)
  • iSCSI (2)
  • regedit (2)
  • scripting (2)
  • 48 (1)
  • 8925 (1)
  • AD group (1)
  • Application Pool (1)
  • Audit (1)
  • BusLogic SCSI (1)
  • CAB (1)
  • CALs (1)
  • CBS (1)
  • CBSPersist (1)
  • CIFS (1)
  • Cabling (1)
  • Cache (1)
  • Certificates (1)
  • Checklist (1)
  • Copy (1)
  • CrashOnAuditFail (1)
  • Credential Manager (1)
  • Credentials (1)
  • DFM (1)
  • Debug programs (1)
  • Disk (1)
  • Disk Ownership (1)
  • Driver (1)
  • Drivers (1)
  • EMC (1)
  • EMC Troubleshooting (1)
  • ESXi 5 (1)
  • Encryption (1)
  • Exchange 2007 (1)
  • FIPS (1)
  • Firewall (1)
  • Flickr (1)
  • Folder Redirection (1)
  • Get-ADComputer (1)
  • Get-ADGroup (1)
  • Get-ADGroupMember (1)
  • Get-ADUser (1)
  • HOSTS (1)
  • HTTP (1)
  • Hidden Device (1)
  • IE8 (1)
  • IIS7.5 (1)
  • IPSec (1)
  • Installation (1)
  • Intel (1)
  • Interoperability (1)
  • JDK (1)
  • JRE (1)
  • Large File (1)
  • LastLogonTimeStamp (1)
  • Lockout (1)
  • Logging (1)
  • Logon (1)
  • MOSS 2007 (1)
  • MS Teams (1)
  • Mac Address (1)
  • Mail-enable (1)
  • Malware (1)
  • Management Studio (1)
  • Mapped Drive (1)
  • MaxFreeConnections (1)
  • Maxretries (1)
  • MinFreeConnections (1)
  • Mountvol (1)
  • Move-ADObject (1)
  • Nearstore (1)
  • Netapp Alias (1)
  • NetworkCategory (1)
  • ONTAP (1)
  • Off Topic (1)
  • Oracle (1)
  • Outlook (1)
  • Password Reset (1)
  • Performance (1)
  • Port (1)
  • Ports (1)
  • Print Server (1)
  • Print Spooler (1)
  • Printers (1)
  • Proxy (1)
  • RDS (1)
  • RESOURCE_SEMAPHORE (1)
  • Reboot (1)
  • Registry (1)
  • Reminders (1)
  • Reset Node (1)
  • Resource Kit (1)
  • SAN Certificate (1)
  • SID (1)
  • SMB (1)
  • SMTP (1)
  • SQL Agent (1)
  • SSAS (1)
  • SSH (1)
  • Scale-Out Deployment (1)
  • Scheduled (1)
  • Scheduler (1)
  • Script error (1)
  • Search (1)
  • Services (1)
  • Shell (1)
  • Shutdown (1)
  • Snap Manager (1)
  • SnapDrive (1)
  • SoftwareDistribution (1)
  • Space (1)
  • Storage (1)
  • Subscriptions (1)
  • TLS 1.0 (1)
  • TS (1)
  • TargetServersRole (1)
  • Tech Support Mode (1)
  • TempDB (1)
  • Tilt (1)
  • Time skew (1)
  • Uninstall (1)
  • Updates (1)
  • Upgrade (1)
  • VAAI (1)
  • VMDK (1)
  • View Any Definition (1)
  • WMI (1)
  • WSS (1)
  • Wait (1)
  • Win 2012 R2 (1)
  • Windows XP Runas (1)
  • cheatsheet (1)
  • cifs lookup (1)
  • commands (1)
  • connectivity (1)
  • copy-item (1)
  • corruption (1)
  • esxcli (1)
  • fail (1)
  • fileserver (1)
  • fix (1)
  • get-process (1)
  • gpedit.msc (1)
  • hung (1)
  • iPhone (1)
  • log (1)
  • login (1)
  • members (1)
  • mmc (1)
  • options (1)
  • orphan users (1)
  • orphaned users (1)
  • samaccountname (1)
  • shares (1)
  • startup (1)
  • status code (1)
  • sync (1)
  • syspolicy_purge_history (1)
  • vCPU (1)
  • vihostupdate (1)
  • vsphere 5 (1)

Blog Archive

  • ►  2022 (8)
    • ►  October (4)
    • ►  August (1)
    • ►  May (3)
  • ►  2021 (1)
    • ►  January (1)
  • ►  2019 (1)
    • ►  April (1)
  • ►  2018 (1)
    • ►  March (1)
  • ►  2017 (1)
    • ►  May (1)
  • ►  2016 (1)
    • ►  July (1)
  • ►  2015 (11)
    • ►  December (1)
    • ►  June (1)
    • ►  May (1)
    • ►  April (2)
    • ►  March (2)
    • ►  February (4)
  • ►  2014 (12)
    • ►  December (1)
    • ►  November (2)
    • ►  October (1)
    • ►  July (1)
    • ►  May (2)
    • ►  March (1)
    • ►  February (3)
    • ►  January (1)
  • ►  2013 (14)
    • ►  December (2)
    • ►  June (3)
    • ►  May (3)
    • ►  April (1)
    • ►  March (4)
    • ►  January (1)
  • ▼  2012 (26)
    • ►  December (2)
    • ►  November (4)
    • ►  October (4)
    • ►  September (2)
    • ►  August (3)
    • ►  July (1)
    • ►  June (2)
    • ▼  May (1)
      • Non-sa access to SQL 2000 Jobs
    • ►  April (1)
    • ►  March (2)
    • ►  February (3)
    • ►  January (1)
  • ►  2011 (31)
    • ►  December (3)
    • ►  September (4)
    • ►  August (4)
    • ►  July (2)
    • ►  June (3)
    • ►  May (2)
    • ►  April (6)
    • ►  March (2)
    • ►  January (5)
  • ►  2010 (24)
    • ►  December (3)
    • ►  November (3)
    • ►  October (2)
    • ►  September (2)
    • ►  August (2)
    • ►  July (1)
    • ►  June (2)
    • ►  May (2)
    • ►  April (3)
    • ►  March (1)
    • ►  January (3)
  • ►  2009 (52)
    • ►  December (5)
    • ►  November (3)
    • ►  October (2)
    • ►  September (7)
    • ►  August (21)
    • ►  July (14)