Does anyone know if it's possible, (and furthermore advisable) to update all cmdexec strings in jobs on a server? We'd like to change our logging location, and in principle I'd think this could be ...
This is probably a silly question but if I want a job to run Sunday at midnight would I choose Sunday 12:00AM or Monday 12:00AM?
I am trying to configure the SQL Server Job Agent using the following scripts USE [msdb] GO CREATE USER [mydbuser] FOR LOGIN [mydbuser] GO EXEC sp_addrolemember N'db_datareader', N'mydbuser' GO EXEC ...
The job was invoked by schedule 16 (WIN7DB01 UserDB Backups.Subplan_1). The last step to run was step 1 (Subplan_1). I could not understand what is the cause of this. Please help me.