Questions tagged [jobs]
A scheduled task managed by the database, for example using SQL Server Agent, Oracle dbms_job, or MySQL Event Scheduler.
328
questions
0
votes
1answer
14 views
Chaining remote SQL Server Agent Jobs with success/failure feedback
I have 2 Microsoft SQL Server 2014 (SP3-CU4) instances, residing on different servers.
ServerA has a linked server, pointing to ServerB\InstanceB.
Both instances have a job, and JobA triggers the ...
0
votes
1answer
17 views
SQL Server Gantt Chart of Jobs [closed]
Need a graphical representation of my Job run-times in SQL Server.
I would like to know if there is a software or solution for getting the jobs in to a calendar looking format or Gantt style. I was ...
0
votes
0answers
14 views
gMSA for running a sql agent job
I've had the question if it's possible to add a gMSA-account to the SQL-logins in order to let it perform a certain SQL Agent Job.
I know it's possible to add a gMSA as a login but it will probably ...
0
votes
2answers
54 views
ORA-01658: unable to create INITIAL extent for segment in tablespace SYSAUX; JOB_SCHEDULER is biggest occupant
DBMS_SCHEDULER is occupying all of my SYSAUX tablespace. I ran dbms_scheduler.purge_log which deleted 100 million rows from dba_scheduler_job_run_details, however v$sysaux_occupants and the data file ...
-1
votes
1answer
31 views
SQL Job runs without it schedule and renaming or deleting it causes other jobs fail
I recently migrated the SQL 2008 to SQL Server 2016. I started noticing a strange issue where one of the SQL Job is causing the failure of other jobs. This job is disabled and there is no schedule and ...
0
votes
0answers
50 views
CDC capture Job Step-2 is not running when enabling CDC on table in SQL Server and Change table is empty
My Database has CDC enabled and the table i want to track changes using the below T-SQL,
EXEC sys.sp_cdc_enable_db;
GO
EXEC sys.sp_cdc_enable_table
@source_schema = N'dbo',
@source_name = N'...
1
vote
1answer
15 views
Backup with date to azure blob storage url
Im trying to do backups to an azure blob storage that have the date when the backup is made, that way the job does not fail when the backup is generated with the same name, I am concatenating convert(...
1
vote
2answers
32 views
How to clear SQL Agent Job Scheduler Cache
I have to submit tickets to alter job scheduling, so rather than a walk through of the GUI I try to update msdb..sysschedules via tsql script. I always see the alterations immediately via the GUI. ...
0
votes
1answer
89 views
SQL Server Management Studio Error Access Denied Editing Job Step
I recently changed the owner of a job from my user to sa. After the ownership change I am able to edit the Schedules and Notifications for the job. However all attempts to to create New, Insert, Edit, ...
0
votes
2answers
191 views
Execute sp_update_jobstep to change SQL Agent job step type
As I was going to deploy a change to our Ola Hallengren indexing scripts, I noticed on some SQL Servers we have indexing job running as an "Operating System (CmdExec)" step instead of being called as ...
1
vote
2answers
111 views
Is it better to have one instance of a continuously running agent job or to fire off the job multiple times throughout the day?
I have a SQL query I need to run every second for about 12 hours a day.
It's a pretty simple query that logs some data to an isolated table.
Right now I've been leaving it running in my local SSMS ...
0
votes
1answer
31 views
Scheduled Job Does not work in oracle SQL*PLUS
I am just a beginner in Oracle and can't seem to get this job running :-
I want to delete old rows from my database. And created a job as follows :-
CREATE OR REPLACE PROCEDURE delete_trips
AS
...
2
votes
1answer
182 views
begin tran instead of use db_name inside a SQL Job for executing Stored Procedure
I was defining a SQL job yesterday for executing stored procedure at a specific time in the morning. It was an ad-hoc and urgent requirement and hence I developed this procedure on the fly and ...
0
votes
1answer
93 views
SQL Agent using domain user for Jobs with TSQL
I have tried every option but i still cant find out why my sql agent is using a domain user when executing job steps with TSQL and keep getting the following error:
Executed as user: RESOURCE\...
0
votes
0answers
36 views
A dbms_scheduler job is not running
I need help with debugging why a certain job is not running in Oracle with the dbms_scheduler. I have many other jobs running under the same user/schema and they work.
So, how do I start finding the ...
2
votes
1answer
171 views
Linked Server Timeout - Not Queried
I have a job that runs for multiple regions across the globe. Depending on what region is running and what time zone it's in, the job might not run. It uses GOTO to get to the end and reports that it ...
1
vote
2answers
68 views
Is it possible to query for the job schedule description?
Working on putting together a script to analyze all of the active jobs and I have nearly everything I need, but if possible I would like to be able to query for the schedules description as well. Is ...
1
vote
2answers
79 views
Find jobs that succeeded, but had steps that failed
Is it possible to find jobs that succeeded, but that had steps that failed like the desired output shows? I'm new to this side of development and I'm not sure about all of the system tables, etc. If ...
0
votes
3answers
274 views
Oracle 12c and Jobs running one hour apart after changing time for hourly use
I have an Oracle 12c database in which I have detected that the scheduled jobs are running one hour apart after the change of time on the server, checking in the database I see that the SYSTIMESTAMP ...
0
votes
1answer
60 views
SqlServer Jobs Not Running - Job Activity Monitor
I have several dozen SQL Server jobs that the Job Activity Monitor displays that do not appear to have executed.
Tools used and Version details:
Microsoft SQL Server Management Studio 12.0.6024.0
...
1
vote
0answers
67 views
Why is failed job not logged in SQL Server Agent Error Log?
I have a failed job which is logged in SQL Server Logs but not logged in SQL Server Agent Error Logs. The job is executed as user: NT SERVICE\SQLSERVERAGENT. Limit size of job history and Remove agent ...
0
votes
1answer
62 views
Toad for Oracle: Procedures, Packages, Job, and DBMS_SCHEDULER
If I have about 10 queries which contain subqueries, would it be a best practice to contain all of them in one procedure? This script creates a small fraction of the data required for a report.
DROP ...
4
votes
1answer
260 views
Why the job's next_run_time is wrong?
I got an issue regarding job stats. So I have a job with the following schedule: Occurs every day every 5 minute(s) between 12:00:00 AM and 11:59:59 PM. Schedule will be used starting on 12/13/2017.
...
-1
votes
2answers
89 views
remove a step from sql agent jobs
I copied a bunch of jobs from an HA server to a regular server and I need to delete only the first step( checks for the primary) on these jobs not all jobs. Any suggestion?
this is the query I used to ...
0
votes
0answers
49 views
disabled job still runs
In SQL Server 2014 (currently 12.0.6205) when I disable backup jobs either manually through SSMS or through T-SQL, I am seeing that the job still runs regardless of the job's enable status. Do I need ...
1
vote
0answers
66 views
SQL Server allow viewing of jobs by job category
I know how to assign or create "categories" for jobs. But is there a way to actually view jobs by category by default. I do not want to see all the jobs just listed within SQL Server Agent. I'd ...
0
votes
2answers
73 views
Pending changes from a finished job
I'm getting the following error:
Uncommitted changes pending for file MYTABLE in library MYLIB.
CPF325E
Cause . . . . . : Uncommitted changes are pending for file MYTABLE in library ...
0
votes
1answer
234 views
How can I run a pgAgent job every 10 second?
I have a PostgreSQL 11.3 Database. I installed pgAgent for creating jobs. Now I want to run my job every 10 second, but in GUI there is possibility to write with precision of minutes, not with ...
0
votes
1answer
32 views
Newly created jobs need to be set for failure notifications automatically
Whenever a new / existing job gets failed on an instance of SQL Server, we should recieve an email about failure notification. Please help on how we can automate it?
1
vote
1answer
389 views
Save SQL server job output results to text file
I would like to save results of the SQL job to a text file.
This is the query
SELECT sqltext.text,
req.session_id,
req.blocking_session_id,
req.cpu_time,
req.wait_type,
req.status
FROM sys....
1
vote
1answer
1k views
SQL Server transactional replication is out of sync
I have setup transactional replication in SQL Server and I am using PULL to retrieve the data from the subscriber.
Recently, I noticed that the data in my subscriber is not synced up with the ...
0
votes
1answer
184 views
Mysql 8 event scheduler timezone
im a bit confused about the event scheduler. First off, it is running and working, but the timezone handling confuses me a bit, as it seems it's not what is documented on events metadata
So to start ...
0
votes
0answers
86 views
ORA-27369: job of type EXECUTABLE failed with exit code: There are no child processes to wait for
I have existing .bat file where i call FDSLoader64.exe on daily basis to update following tables.
FF_ADVANCED_AF
FF_ADVANCED_SAF
FF_BASIC_SAF
FF_BASIC_AF
FDSLoader64.exe is supposed to download ...
2
votes
3answers
130 views
Can a MSSQL job change its own active schedule?
I am planning a new job for MSSQL Sever 2016.
I'd like the job to run on Sunday, every 10 minutes, until it sees a confirmation record is added to a table it checks as the final step in the job. If ...
0
votes
0answers
33 views
Automatic Query from root DB to new DB
I have access to an enterprise level DB used throughout the organization with tight constraints on who can access things. It contains almost all our data. I am a user of that DB with only read rights. ...
-1
votes
1answer
180 views
SQL Job failing due to an error [closed]
I am no expert with SQL for sure but I am wondering if I could take a swing at this on my own.
I have an SQL job called "Misc Update NAV" that is scheduled to run every day at 7 am, however, when ...
1
vote
2answers
35 views
SSIS connection used based on passed value
I have an SSIS package that populates a reporting warehouse from a live and test environment.
Currently the package has each step duplicated as the source connection changes between live and test. ...
4
votes
2answers
857 views
Start job from another SQL server instance
I have a job on an SQL 2008 server (Server A) (I know this is not ideal... That issue is being addressed). The agent runs under NT AUTHORITY\NETWORK SERVICE.
I want to add a step that runs a job that ...
1
vote
2answers
109 views
is it possible to trim the table output for a specific job?
I have a routine to save the logins and apply them on a different server , and I run this routine from a job that I have scheduled to run everyday.
On that job I have specified these 3 things:
Log ...
0
votes
0answers
460 views
Create SQL Server Agent job for stored procedure with input parameter
Could you suggest please how to create SQL Server Agent job for a stored procedure that have 1 input parameter?
The procedure is correctly created and i executed it using this code :
EXECUTE dbo....
0
votes
2answers
700 views
Triggers vs. Jobs in SQL Server
I’m designing a database with a table that automatically gets loaded with a new record every 15 seconds (each record will have a 'timestamp' field and around 50 ‘float’ fields). Each record in this ...
2
votes
1answer
368 views
Run SQL Agent Job 3 times in a Row
How do I execute SQL Agent job 3 times in a row?
We are creating Data Warehouse Project. It ETLs data from Flatfile Legacy Folder, and creates Dim and Fact tables.
SSIS Project Environment Variable (...
3
votes
1answer
710 views
How to handle failed Index Optimization (Ola Hallengren) step in SQL Azure Elastic Job Agent?
I have created a SQL maintenance job using Azure Elastic Job Agent with the following step:
EXEC jobs.sp_add_jobstep @job_name = @jobName,
@step_name = 'Optimize indexes and statistics',
@command=N'
...
1
vote
2answers
686 views
Run shell script on Oracle 11g
I have an oracle database:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
"CORE 11.2.0.1.0 Production"
TNS for Linux: Version 11.2.0.1.0 - ...
1
vote
1answer
2k views
Does SQL server log when and who enabled / disabled jobs by default?
Is there any default logging or history of when a SQL job was enabled or disabled?
0
votes
2answers
439 views
Stop long running scheduled job
I need to launch a scheduled job at 12 o'clock at night and keep this job running for a period of 8 hours. What happens now is that the job is running for more than 12 hours and I really need to avoid ...
0
votes
0answers
62 views
Ola Hallengren - Parallel Backup Jobs failing on SINGLE_USER DB - 'Database is in transition' [952]
I'm using Ola's DatabasesInParallel option for "multi-threaded" execution. Last night a db was temporarily placed into SINGLE_USER for an application-based archive process and it caused all 5 threads ...
5
votes
1answer
674 views
What's the values for the Freq_Interval column in MSDB.dbo.SysSchedules when Freq_Type is weekly and more than one day is selected in the schedule?
I'm reading up on the SysSchedules table in the Microsoft API, and am trying to incorporate using this table in a query.
In the documentation, the Freq_Interval column seems to be defined out for ...
4
votes
1answer
332 views
Why are these T-SQL jobs from different SQL Server instances executed on the same instance (AlwaysOn Availability Groups)
Recently, our blocked processes dashboard has been reporting blocked processes around the time when we do our statistic update.
The reason was quickly found: an update statistics job step (T-SQL) ...
3
votes
5answers
745 views
How to stop a job for the rest of the day after the relevant condition has been satisfied once?
I have a job that runs every 5 minutes to check an IF condition. If the condition is true, it will send an email, if not, it won’t do anything.
My problem is that once the IF condition is true, it ...
