The jobs tag has no wiki summary.
8
votes
2answers
240 views
How does SQL Server store the information in Job Schedule Properties?
I know there is SELECT * FROM msdb..sysjobschedules, but that just shows the next time a job is scheduled to run.
I want to know how this is all determined and stored. So where does it store the ...
3
votes
2answers
83 views
Update strings for all cmdexec Jobs
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 ...
3
votes
2answers
266 views
Disabling DBMS_SCHEDULER queue
Despite a lot of searching, I can't seem to find a solution to this problem we are having.
Our system enables users to submit certain processes to be run in background while they continue working. ...
3
votes
1answer
36 views
Creative workaround for granting edit rights to individual jobs for a group?
We have two developers that say they can not function without full rights to a few jobs on our database server. They both want rights to the same jobs.
Given that it seems that MS doesn't seem to be ...
3
votes
2answers
333 views
Transaction and Try-catch in SQL Server Job
We have DML operations in each step of a SQL Server job. To ensure the update/insert will be rolled back in case something goes wrong, I have wrapped the data modifications of each step in TRY CATCH ...
2
votes
2answers
231 views
How to find when last reindexing happened in sql server?
I have set 'job' for re-indexing, I want to know when the last re-indexing happened in datetime.
2
votes
0answers
65 views
Configuring SQL Server Job agent
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 ...
1
vote
2answers
168 views
Calling a SQL Server job within another job
Is it possible to call a SQL Server job to run within another job?
I know we can add all steps of Job 1 to Job 2, but I prefer not to do that. First the Job 2 is already quite big and second I ...
1
vote
1answer
103 views
Force chain to start immediately after completion instead of on a timer
Is it possible to force an Oracle chain to restart immediately after it finishes executing, instead of on a timer? I have only found ways to do a temporal restart, which doesn't really work for me as ...
1
vote
0answers
210 views
Login failure when running a SSIS package from a SQL Server job
I have a SSIS package that migrates data from a Sybase database to SQL Server. The connection to the source database has been made through an ODBC connection.
If I run the package directly on my ...
1
vote
1answer
101 views
Can't do any changes to a job in SQL 2000
I have a job in my SQL 2000 server, this job is used to execute a DTS, i want to change the schedule of this job.
but every time i try to change of delete or stop this job i get the error message
...
0
votes
1answer
105 views
SQL Server Job logging best practice
To be able to design a robust Job in SQL Server, we need to have log for each step of the job. I know there are different options available which help us for troubleshooting a job, but what if we want ...
0
votes
1answer
73 views
Postgresql Run 'Jobs' At Specific Times
I have a normal problem to anyone that can't trust on applications to do their 'work/ AKA be online' and needs a DB Stored Procedure to run every minute .
Scenario :
PostgreSQL 9.2
Need To Run A ...
0
votes
3answers
72 views
SQL agent job step's connection managers
Is there any way with T-SQL to list the connection managers that are used in an SQL Agent Job step?
0
votes
0answers
58 views
Dates, times and SQL jobs [closed]
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?
0
votes
1answer
62 views
A failure in SQL Server backup job [closed]
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.
0
votes
0answers
379 views
How much does a Junior Oracle DBA get paid? [closed]
I have a pretty good background in programming (SQL/PL-SQL/DB Design/Modeling) and in computers in general... no actual DBA experience (yet!) wondering roughly how much jr dbas get paid ?
It seems ...
